ms sql use like statement result in if statement

Posted by Asha on Stack Overflow See other posts from Stack Overflow or by Asha
Published on 2010-04-08T15:54:55Z Indexed on 2010/04/08 16:03 UTC
Read the original article Hit count: 668

declare @d varchar
set @d = 'No filter'

if (@d like 'No filter')
  BEGIN
    select 'matched'
  end
else
  begin
    select 'not matched'
  end

© Stack Overflow or respective owner