Thursday, 4 April 2013

Find Set Of Text and substring it in SQL

Declare @Test AS Varchar(60)
Declare @Test1 AS Varchar(60)
SET @Test =  'This is used to find and replace This'
Select  PATINDEX('%i%',@Test)


No comments:

Post a Comment