Posted by Brian on 04/25/07 13:41

I must be doing something wrong, this is my error.

Msg 547, Level 16, State 0, Line 3
The UPDATE statement conflicted with the REFERENCE constraint
"FK_GL_TrnsLne_IMA". The conflict occurred in database "EAGLE", table
"dbo.GL_TrnsLne", column 'GLL_ItmID'.
The statement has been terminated.

"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]