Seperating parts of a string

[Brian1219]

I am currently trying to seperate values in a column that are in the following format

abcd-wxyz

There can be any number of letters before AND after the dash. The only information I need to obtain is everything to the RIGHT of the dash. I know in Oracle there is an "intstr" function. However, I am having problems finding a similar function in SQL server 7.

Any Help would be greatly appreciated.

Thanks in advance

 

[tlbroadbent]

Use CHARINDEX or PATINDEX.

Select right(colname,len(colname)-charindex('-',colname)) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Brian1219]

Thanks!