UPPER CASE in Update Statement.

October 26, 2010

UPPER CASE in Update Statement, use following syntax for the same.
Syntax:
UPDATE Table_Name
SET Column_Name = UPPER(Column_Name)
Example:
UPDATE Table_Name
SET UserName = UPPER(UserName)


UPPER CASE in Select Statement.

October 22, 2010

In the case if you want your column values in CAPs format or in Upper Case, use following syntax for the same.
Syntax:
SELECT UPPER(Column_Name) FROM Table_Name
Example:
SELECT UPPER(UserRole) FROM Users


Follow

Get every new post delivered to your Inbox.