How do you return nth occurrence of something in the str

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:03:28

Borislav Borissov
Microcomplex
Sofia, Bulgaria

16/12/2008 07:38:33

Naomi Nosonovsky
Wisconsin, United States

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:

01367802

Views:

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

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Map

View

Click here to load this message in the networking platform