COmparing an Alphapet in Store Proc

• Sureshbabu Sankarasubbu

  SSC Enthusiast

  Points: 162

  More actions

  September 1, 2005 at 8:02 am

  #88945

  Hi All,

      I am writing a store procedure where ineed to compare the alphabets available in2 different variables. Pls confirm whether it is correct.

  Both the Variables are Declared as CHar(1)

  set @status  = 'R'

  Set @Tol_status = 'U'

  can i do the Compare like this as said below or there ia any other way ?

  if(@Status = @Tol_Status)

  -- Do Manipulations

  Else

  -- Do Manipulations

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  September 1, 2005 at 8:23 am

  #586840

  Have you tried it? Many times it's pretty easy to mock up something simple to test code behaviours..

  declare @status char(1), @Tol_status char(1)

  set @status = 'R'

  Set @Tol_status = 'U'

  if(@Status = @Tol_Status)

    begin

   print 'Matches'

    end

  Else

    begin

    print 'No match'

    end

  /Kenneth

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  September 1, 2005 at 7:15 pm

  #587074

  Also keep in mind collations and case sensitive/insensitive databases...if that matters!!!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**