Monday, April 25, 2011

Converting the data in column from Upper case to Camel Case

Two ways to achieve this functionality are listed Below:

UPPER(SUBSTRING(Comment_Text FROM 1 FOR 1)) || upper(substring(Comment_Text.STATUS FROM 2))

or

EVALUATE(‘INITCAP(%1)‘, Table.ColumnName)

No comments:

Post a Comment