string function - convert to upper/lower case 1

[password99]

what is the SQL function to convert column value to upper or lower case?

select upper(name) from table should return names in upper case??

 

[scriverb]

Try the UCase(String) function. This will convert all characters to Upper Case. Conversely use LCase(String) to return all characters in string to lower case.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]