Home Forums SQL Server 2008 SQL Server Newbies How to eval @Variable when assigned from SELECT field? RE: How to eval @Variable when assigned from SELECT field?
ColdCoffee
SSC-Dedicated
Points: 39971
More actions
October 1, 2012 at 4:49 pm
#1544193
That is because you are SETting the value for your variable before the SELECT statment..
SET @MyNumberReturn = '000000'
You code should be
IF @MyNumberReturn = '000000' OR @MyNumberReturn IS NULL
THEN
PRINT 'NOTHING'
ELSE
<DO SOMETHING>