Solved

T-SQL to find position of second occurence of a substring in a string

Posted on 2008-10-13

1 solution

3,656 Views

Last Modified: 2012-05-05

Hi,
I need a T-SQL script to find position of second occurence of a substring in a string

Comment

Question by:david_32

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 143

Accepted Solution

by:Guy Hengel [angelIII / a3]

Guy Hengel [angelIII / a3] earned 500 total points

ID: 227089582008-10-13

you have to use CHARINDEX 2 times..

DECLARE @search_string VARCHAR(100)
DECLARE @needle VARCHAR(100)
SET @needle = 's'
SET @search_String = 'string in s1' 
SELECT @search_string, @needle, CHARINDEX(@needle, @search_string, 1+ charindex(@needle, @search_string) )

Open in new window

LVL 28

Expert Comment

by:imran_fast

ID: 227090002008-10-13

you can use the charindex function
below is the example of how to find second location of str in stringstr

select charindex('str','stringstr',charindex('str','stringstr')+1)

Open in new window

LVL 1

Expert Comment

by:Kumawat_Shobha

ID: 227093662008-10-14

try it like this
declare @str      varchar(60),
      @str1      varchar(10)

select      @str      =      'nehashobhasnehashobhatripthi',
      @str1      =      'shobha'

select charindex(@str1,@str,charindex(@str1,@str)+1)

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

5 Lessons the Delta Outage Should Teach Us About Datacenter Security and Disaster Prevention

Article by: Concerto Cloud

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…

The world is on the move: Electronic commerce to Connected commerce

Article by: Shakshi

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.

Creating and Executing a SQL Pass-thru Query

Video by: TechMommy

Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…