LIKE not working with @Variable comparison

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  May 23, 2004 at 6:11 pm

  #161926

  PLEASE DISREGARD THIS POSTING - I HAD MY VARAIBLES SWITCHED...  SORRY! 

  I am not sure why this does not work (I have tried adding muliple wildcards and just comparing the system, but it still didn't work). 

  This is the basic code

  DELCARE @test-2 varchar(10),

                @Sentence varchar(50)

  SELECT @test-2 = 'System',

              @test-2 = '%' + SUBSTRING( @test-2, 1, 4) + '%',

              @Sentence = 'This is a tes of the system'

   

  IF @test-2 LIKE @Sentence

       BEGIN

            PRINT 'Yes'

   

  I wasn't born stupid - I had to study.

• gareth_keen

  SSC Enthusiast

  Points: 151

  More actions

  May 24, 2004 at 3:08 am

  #507428

  DECLARE @test-2 varchar(10),

                @Sentence varchar(50)

  SELECT @test-2 = 'System',

              @test-2 = '%' + SUBSTRING( @test-2, 1, 4) + '%',

              @Sentence = 'This is a tes of the system'

   

  IF @Sentence  like @test-2

       BEGIN

            PRINT 'Yes'

  end

  Glyndwr

• Calvin Lawson

  SSChampion

  Points: 11030

  More actions

  May 24, 2004 at 7:41 pm

  #507564

  It's more clear when written this way:

  DECLARE @test-2 varchar(10),

                @Sentence varchar(50)

  SELECT @test-2 = 'System',

         @test-2 = SUBSTRING( @test-2, 1, 4),

         @Sentence = 'This is a tes of the system'

  IF @Sentence  like  + '%' + @test-2 + '%'

       BEGIN

            PRINT 'Yes'

  end

  Signature is NULL