test if string contains a character

[dky1e]

Is there a funtion to test if a string contains a character specified? Similar to IndexOf function in .net sdk?

Here's my pseudo code:
declare @test
select @test = 'asdf'
if indexOf( @test, 'a' ) > 0
begin
do stuff
end

 

[Niv3k]

PRINT patindex ('%[A-Za-z]%','123a')
will return 4

PRINT patindex ('%[A-Za-z]%','123')
will return 0

 

[Niv3k]

So if you are looking for 'a' replace the

%[A-Za-z]% with %a%

for case insensitive do %[Aa]%

Use both % (wildcards in SQL) unless you want a field that starts with a: [aA]% or ends with a: %[Aa]

 

[dky1e]

how would I use it if I am using variables?
How do I use the '%' character?

 

[dky1e]

here we go... I found an alternative.
SELECT CHARINDEX('w', 'wonderful')