>>>Hi everybody,
>>>
>>>I'm thinking how would I return nth occurrence of a string within a string?
>>>
>>>Thanks in advance.
>>
>>You must write your own UDF.
>
>Check
http://forums.asp.net/p/1361391/2812741.aspx#2812741Nope, I don't like CTE more :-)
CTE could be SLOW!!!!
Remember you can't optimize the query that uses CTE. CTE has NO indexes :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.