How to find No. Of occurences in a string without Loop

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Jonathan Stokes SSCrazy Eights Points: 9861 More actions · Answer 1

There is no inherent function in sql.

Even in vb you need to loop through the characters to perform the task.

You are looking at writing a script using the 'substring' function to find each ocurrence and trap it soemwhere.

------------------------------
The Users are always right - when I'm not wrong!

WSquared SSCrazy Points: 2393 More actions · Answer 2

Check out this link

mamidimahesh-127681 SSC Eights! Points: 868 More actions · Answer 3

Thanks for your reply.

Sorry, If i use StringCount function that Stringcount function should exists in my database. I don't want that. Any System function available ?

Bobby

WSquared SSCrazy Points: 2393 More actions · Answer 4

Not really sure why u don't want a function or sp in your db, but try this

Select Len('a,b,c,e,3') - len(Replace('a,b,c,e,3',',',''))

this assumes that you don't have any embeded spaces in the string

mamidimahesh-127681 SSC Eights! Points: 868 More actions · Answer 5

Thanks a lot. My PL said without using a any loop i should get the output.

Thanks again.

Bobby

Cookies on SQLServerCentral