query delete some part of string

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Ben Teraberry SSChampion Points: 11845 More actions · Answer 1

Might be a slightly cleaner way, but this works:

select case charindex('.', Column1)

when 0 then Column1

else stuff(Column1, charindex('.', Column1), charindex('\', Column1, 3) - charindex('.', Column1) - 1, '') end

from @t_temp;

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Cory E. SSCertifiable Points: 7076 More actions · Answer 2

SELECT ISNULL(STUFF(@str, CHARINDEX('.', @STR), CHARINDEX('\', @STR, 3) - CHARINDEX('.', @STR) - 1, ''), @STR);

-- Cory

Ben Teraberry SSChampion Points: 11845 More actions · Answer 3

Of course ^

ISNULL is better than doing a CASE.

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Cory E. SSCertifiable Points: 7076 More actions · Answer 4

bteraberry (5/7/2010)
Of course ^
ISNULL is better than doing a CASE.

Oh good, I was able to save face for that substring inefficient code. 😀

-- Cory