How do you return nth occurrence of something in the str - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How do you return nth occurrence of something in the str

Message

From

16/12/2008 08:15:08

Sergey Berezniker
New York, United States

To

16/12/2008 08:03:28

Borislav Borissov
Microcomplex
Sofia, Bulgaria

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: How do you return nth occurrence of something in the str

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01367797

Message ID:

01367810

Views:

6

This message has been marked as the solution to the initial question of the thread.

>>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.

Or you can use one I posted in UtMag a few years ago http://www.utmag.com/ViewPageArticle.aspx?Session=637455566E646A46346C733D207A53716C386C437A6F6E4B6668532F4A692B486F6D413D3D

--sb--

Click here to load this message in the networking platform