right of last instance of characters

Question

Viewing 7 posts - 1 through 7 (of 7 total)

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

Marshall Smith SSCrazy Points: 2041 More actions · Answer 1

Use the left and first instance method, on the REVERSE of the string.

stax68 SSChampion Points: 11761 More actions · Answer 2

that way you don't need to reverse three times to do it inline.

Tim Wilkinson

"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant

stax68 SSChampion Points: 11761 More actions · Answer 3

Not in TSQL you can't.

[edit: oh i see it's a UDF. There are better ways of splitting strings though. But this request was not about doing that anyway.]

Tim Wilkinson

"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant

Bhushan Default port Points: 1427 More actions · Answer 4

You can use

select * from Split('memememe::kjsdfkjfds::ksjf::iuhsaf

sdffsd::safsdf

sdffs::sdfsdf:11231231::safdsfds::sdffssdf::sdfs

sdfsdffsdfsdf::sdfsdf::sfsdf::sdfsdf::sadfdssfds

dsffsfdfsdfsfdsfddf::sdfsfsfdfdssd::sdfsddfsdf','::')

stax68 SSChampion Points: 11761 More actions · Answer 5

I didn't use a double colon, but it works for any string (subject to length restrictions).

@str varchar(8000)

set

@str = 'ad::d'

select

substring

( @str,len( @str)-charindex('::',reverse( @str))+2,8000)

Tim Wilkinson

"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant

geoff hopkins Ten Centuries Points: 1147 More actions · Answer 6

sorry I did not say thanks earlier but been away, so thanks,