Incorrect Syntax Near "="
I'm trying to make dbo.OrgUnits.OrgPath = "NB" when dbo.OrgUnits.OrgID is null. However I get an error message of 'Incorrect Syntax Near "="' with my code (see below). Can someone please tell me what I'm doing wrong.
SELECT dbo.GLAccounts.GLID, dbo.GLAccounts.BaseID, dbo.OrgUnits.OrgID, dbo.OrgUnits.OrgPath, dbo.OrgUnits.OrgLongName,
Case
When dbo.OrgUnits.OrgID=""
Then dbo.OrgUnits.OrgPath="NB"
End
FROM dbo.GLAccounts LEFT OUTER JOIN
dbo.OrgUnits ON dbo.GLAccounts.OrgID = dbo.OrgUnits.OrgID
|