jchandramouli
SSCommitted
Points: 1772
More actions
January 27, 2009 at 12:37 am
#199245
Hi,
I have a string say, @vch= 'DMJ944542' .
How to extract just 944542 from this...
Thanks in advance.
"I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin
Mark Cowne
One Orange Chip
Points: 26944
January 27, 2009 at 12:47 am
#933031
select substring(@vch,patindex('%[0-9]%',@vch),100)
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
January 27, 2009 at 1:03 am
#933035
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply