Posted by Brian on 04/25/07 14:51

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?
Sorry, Im kind of a newby and trying to be cautious.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns991CF3BC13E36Yazorman@127.0.0.1...
> Brian (b.houghtby@eaglecrusher.com) writes:
>> How can I change a character in a string of text. I have a bunch number
>> that have a lower case l in them and I need to make them an uppercase L.
>> Example; 99l5555 needs to be 99L5555.
>
> UPDATE tbl
> SET col = replace(col, 'l', 'L')
>
> Or if there other lowercase as well that should be uppercase:
>
> UPDATE tbl SET col = upper(col)
>
> --
> 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]