How to truncate String column using sql query.

[anilreddy76]

Hi,

I'm having one location table where the values of location are returned as KC_KansasCity,CHAR_Charlotte,PEW_Pewauke etc,I want to truncate the characters before underscore and also underscore while inserting the data into table.

Can anybody advise me on how to do this..

Thanks,
Anil

[bubbisthedog]

Don't know what product you're using (MySQL, SQL Server, etc.), but I'd suggest researching substr() and instr().

[mattyblah]

the equivalent functions bubb suggested are substring and charindex/patindex for sql server.

[bubbisthedog]

Thanks, matty. :)