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?

  • 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>