Syntax error (2002)

Topic

New Reply

I’m getting Syntax error (missing operator) when running the following inside a SQL string in VB Code:

StrConv([RANK] & “” “” & [FNAME] & “” “” & IIf(IsNull([MI]),””””,[MI] & “”. “”),3) & “” & StrConv([LNAME] & “” XXX XX “” & Right([SSN],4),1) & “”/”” & [MOS] & “” “” & IIf([orders_type]=””RESERVIST””,””USMCR””,””USMC””) AS FULLNAME

Reply | Quote

Replies

After a slower look and better read-through, I fixed it by changing this:

StrConv([RANK] & “” “” & [FNAME] & “” “” & IIf(IsNull([MI]),””””,[MI] & “”. “”),3) & “” & StrConv([LNAME] & “” XXX XX “” & Right([SSN],4),1) & “”/”” & [MOS] & “” “” & IIf([orders_type]=””RESERVIST””,””USMCR””,””USMC””) AS FULLNAME

to this:

StrConv([RANK] & “” “” & [FNAME] & “” “” & IIf(IsNull([MI]),””””,[MI] & “”. “”),3) & “””” & StrConv([LNAME] & “” XXX XX “” & Right([SSN],4),1) & “”/”” & [MOS] & “” “” & IIf([orders_type]=””RESERVIST””,””USMCR””,””USMC””) AS FULLNAME

Reply | Quote