[sql] How to Compare two strings using a if in a stored procedure in sql server 2008?

I want to do something like this:

declare @temp as varchar
    set @temp='Measure'

if(@temp == 'Measure')
   Select Measure from Measuretable
else
   Select OtherMeasure from Measuretable

This question is related to sql sql-server tsql sql-server-2008 string-comparison

The answer is

Two things:

Only need one (1) equals sign to evaluate
You need to specify a length on the VARCHAR - the default is a single character.

Use:

DECLARE @temp VARCHAR(10)
    SET @temp = 'm'

IF @temp = 'm'
  SELECT 'yes'
ELSE
  SELECT 'no'

VARCHAR(10) means the VARCHAR will accommodate up to 10 characters. More examples of the behavior -

DECLARE @temp VARCHAR
    SET @temp = 'm'

IF @temp = 'm'
  SELECT 'yes'
ELSE
  SELECT 'no'

...will return "yes"

DECLARE @temp VARCHAR
    SET @temp = 'mtest'

IF @temp = 'm'
  SELECT 'yes'
ELSE
  SELECT 'no'

...will return "no".

[sql] How to Compare two strings using a if in a stored procedure in sql server 2008?

The answer is

Similar questions with sql tag:

Similar questions with sql-server tag:

Similar questions with tsql tag:

Similar questions with sql-server-2008 tag:

Similar questions with string-comparison tag:

Tags