How to use a LIKE statement inside an IF statement?

I need to be able to check if a variable has a certain string of text inside it. Here's what I have now:

--This sample always goes to the ELSE block.
IF( @name LIKE '%John%' )
BEGIN
    --do one thing
END
ELSE
BEGIN
    --开发者_如何学编程do the other thing
END

---

dunno...works for me

declare @name varchar(45)

set @name = 'johnson'

IF( @name LIKE '%John%' )
BEGIN
    print 'like'
END
ELSE
BEGIN
    print 'dislike'
END

---

The syntax is fine. If it isn't working for you, it could be down to the collation of your database.

If you have a case sensitive collation, then it will NOT match unless the case matches. e.g. if @name is 'Something john said', then a LIKE searching for "John" will not find a match, hence will go to the ELSE.