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

• Next in forum: OPENQUERY UPDATE Syntax help needed
• Prev in forum: getdate() problem: where is the time taken from ?
• Thread view: Re: sql script

[Reply to this message]