SQL Query Incorrect syntax near @parameter

Question

Declare @motherTongue varchar(20) = 'Doesn''t Matter' 

if (@motherTongue = 'Doesn''t Matter') 
begin
    @motherTongue = null 
end

I am getting an error:

Incorrect syntax near '@motherTongue' error

I am just a beginner.

yes the red underline of syntax error is shown on second one only. — Abhilash Srivastava
– Abhilash Srivastava, Commented Mar 6, 2016 at 5:58

Pரதீப் · Accepted Answer · 2016-03-06 06:53:06Z

2

You need to use SET/Select to assign value to a variable

if(@motherTongue = 'Doesn''t Matter') 
Begin 
SET @motherTongue = null  --Here 
End

But I will do this using CASE instead of IF

SET @motherTongue = case when @motherTongue = 'Doesn''t Matter' then NULL END

You can use NULLIF as well

SET @motherTongue = NULLIF(@motherTongue,'Doesn''t Matter')

answered Mar 6, 2016 at 6:20

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1