Return part of a value in a field

[texusgirl]

Hey everyone!
I am trying to dump some data and have a field called desc that has a vendor# at the end of the field within parens. I need to extract only that part of the field...any suggestions? Example desc = Test Data blah blah (V#1234); the only part of this field I need to dump is the (V#1234)
Thanks in advance,
texusgirl

 

[lespaul]

SUBSTRING (DESC, CHARINDEX('(', DESC), LENGTH(DESC))

put this in your select statement and you should get what you're looking for.

HTH

Leslie

 

[lespaul]

minor change - use this:

SUBSTRING (DESC, CHARINDEX('(', DESC) - 1, LENGTH(DESC))




Leslie

 

[texusgirl]

Worked like a charm! Thank you so much.
texusgirl