Posted by Brian on 04/26/07 20:15

Sorry, Let me start over. I am trying to do a mass change of a bunch of
numbers that a user entered incorrectly. He entered them with a lower case
letter instead of uppercase. The numbers all begin with a 99l and I want to
do a mass replace to change them all to a 99L. The numbers have a suffix
that is not constant like the prefix. Example; 99l555, 99l556, 99l557 and
so on.

The name of the table is dbo.item and the column is ima_itemid. Here is my
select statement.

Select * from dbo.item where
ima_itemid like '99l%'

This result gives me a mixture of 99l's and 99L's. So apparently the user
eventually started entering them the correct way, in case that is an issue
having a mixture. It appears that my select statement doesn't care about
case since I get upper and lower, although I used lower in my select. Hope
this clarifies some.


"Brian" <b.houghtby@eaglecrusher.com> wrote in message
news:462e6d3d$0$24704$4c368faf@roadrunner.com...
> 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.
>

[Back to original message]