TSQL on SUBSTRING

[benchpolo]

Data:
SPIRIVA CAP HANDIHLR
HYDRALAZINE TAB 25MG

Can someone please assist me using SUBSTRING to just filter SPRIVA and HYDRALAZINE value ?

Thanks

[yarbrough40]

Can you give more detail here? What is your larger task? The correct answer will depend on a few things. There are several ways to parse out a text.

[ck9663]

If you're trying to grab the first word before the first space, use CHARINDEX to get the position of first space and use SUBSTRING to get the string you need, relative the the position that the CHARINDEX will return.

Good Luck!!!

~~ CK

[gpl]

Take a look at the final result of this thread http://bytes.com/topic/sql-server/an...numbers-string
It gives a simple method of retrieving values from a tokenised string