if @variable = '' SET @value = 'No option selected!' else SET @value = 'They selected ' + @variable + '.'