Posted by Erland Sommarskog on 04/25/07 15:33
Brian (b.houghtby@eaglecrusher.com) writes:
> In your second example, is the word upper referring to a L in this case.
> Seems like that would just replace everything in that column with an L?
In the case of:
>> UPDATE tbl SET col = upper(col)
"abc123" will be converted to "ABC123". That is, the upper function replaces
lowercase characters to the corresponding uppercase characters according to
the rules of the collation for the column.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|