For ex:if String contains string 'X' then it shouldsatisfy certain condition.
if(contains(var,'xyz'))
begin
-----
end
This querry given me error.
How should i check string?
Plz help me out.....
How to check string in if condition in sql server 2005
I want to check string in if condition:
For ex:if String contains string 'X' then it shouldsatisfy certain condition.
if(contains(var,'xyz'))
begin
-----
end
This querry given me error.
How should i check string?
Plz help me out.....
For ex:if String contains string 'X' then it shouldsatisfy certain condition.
if(contains(var,'xyz'))
begin
-----
end
This querry given me error.
How should i check string?
Plz help me out.....
Posted May 31, 2011, 4:11 AM
declare @string1 as varchar(10)
set @string1 ='xyz1'
if(Charindex(@string1,'xyz1',0) > 0 )
begin
print 'here'
end