Question

我需要能够检查一个变量是否在其内部有某种案文。这里我要说的是:

--This sample always goes to the ELSE block.
IF( @name LIKE  %John%  )
BEGIN
    --do one thing
END
ELSE
BEGIN
    --do the other thing
END

Answer 1

dunno....works for me

declare @name varchar(45)

set @name =  johnson 

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

Answer 2

罚款。如果它不为你工作,那么它就可细分为您的数据库。

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.

友情链接