use the link that sq95m.. has posted!!!

hmm - I wonder if Saravanan and Gogula are working on the same project..

error description

Just to illustrate Frank's methods..

declare @string varchar(50)
set @string = 'Frank and John are back'

if charindex('Jo', @string) > 1
  print 'exists'
else
  print...

oh I'm used to the fact that you're "rarely wrong"...AND since I'm not one of the "guys"..hopefully whoever you're addressing in your post will come along and respond before you...

moral of the story - "search" all you want and "argue" all you want...remi's solution is ALWAYS the only right one...I only said "left" for that play on words that...

It's certainly been a looooooooooong while - almost feels like another lifetime - the "good old days"...

remi - I'll let the original poster...

wow - remi and noel online at the same time - this hasn't happened for a long time..

here're some more - "just for the fun of it"..

Hi noel - thanks for being "translator & interpreter" of my post...

You don't say if you enabled this or not...did you try with ANSI_NULLS and ANSI_WARNINGS ON ?!?! Did you get a different error message ?!

IF LEFT('Letter', 1) = 'L'
    PRINT 'Correct'
ELSE
    PRINT 'Wrong'

I "resisted" this thread only because Steve moved away from "Anything that is not SQL" - (wisely so, I may add) - & I wasn't even aware of the new...

Dan - I couldn't help smiling as I read through your rant...Just as an FYI, here's what I personally do when I'm reading something that is work-related - be it...

Because women have been so ill-represented, I'll have to make mine an all-female list!

Again, not in order of importance or influence - or necessarily global...

Sivakumar...it'd help immensely if you outline your ultimate goal...

Here's one way of doing it dynamically but I'm +ve that you'd get several different non-dynamic/non-cursor solutions if you posted your objective...

Hi Gogula...you could capture @@error in a variable and then use it to query the sysmessages table in the master db..something like this...

select description from master.dbo.sysmessages
where error = @errNum...