|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
string searchfrom a string like - [text].[text].[text].&[1]&[4], I need to extract the
numbers alone. Can someone help me with a function that searches and returns the numbers within the "&[ ]" pattern? thank you! Look at the PATINDEX function in BOL
Show quote "Rama via SQLMonster.com" <fo***@SQLMonster.com> wrote in message news:52C5123420ADD@SQLMonster.com... > from a string like - [text].[text].[text].&[1]&[4], I need to extract the > numbers alone. > Can someone help me with a function that searches and returns the numbers > within the "&[ ]" pattern? > > thank you! > > > -- > Message posted via http://www.sqlmonster.com  |
|||||||||||||||||||||||
Other interesting topics