declare @searchterm nvarchar(200)
SET @searchterm = 'blood and sweat'
SELECT charindex(@SearchTerm,'and'), charindex('and', @SearchTerm)

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

     Jul 13  

Sometimes this is me

     Jul 13  

Sometimes this is me