declare @charpos int

declare @searchterm nvarchar(max)

SET @searchterm = 'blood and sweat'

set @charpos = charindex('and', @SearchTerm)

IF (@charpos = 0) --Check to make sure string position was found

BEGIN

print 'charindex not working as I think it should [Smile] '

print cast(@charpos as varchar(max))

END

else

BEGIN

print 'charindex is working [LOL]'

print cast(@charpos as varchar(max))

END

highlight "charindex" in your query panel and press F1