T-SQl Extract

gregalb · March 13th, 2007, 03:52 PM

I am wanting to extract data from a column either by specifying the length of the data or when the data ends with ????

Thanks

Greg

r_ganesh76 · March 13th, 2007, 04:56 PM

You can use RIGHT and LEN methods to get the right most charecters and the total length of the string.

Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...

happygv · March 14th, 2007, 12:59 AM

You can use SUBSTRING function of SQL. Also look for String functions in Books online to choose the one that fits your requirement the most.

Code:

Select Substring(col1, 1, 15) from Table_Name

Cheers

_________________________
- Vijay G
Strive for Perfection