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

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How do you return nth occurrence of something in the str

Message

De

16/12/2008 08:15:08

Sergey Berezniker
New York, États-Unis

À

16/12/2008 08:03:28

Borislav Borissov
Microcomplex
Sofia, Bulgarie

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

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

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01367797

Message ID:

01367810

Vues:

7

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