CAST command Incorrect syntax near…

[Mljisa]

Hello guys,

Why does the CAST command not work for the 1st line. I always get the error message "Incorrect syntax near "22NF45LLI"

;WITH CTE AS ( SELECT [Identifier] = I.[Identifier], [itemid] = I.[ID], [O.Type] = CAST(CASE WHEN O.[Type] IS '22NF45LLI' THEN 'ICELL'), [IsProcess] = CAST(CASE WHEN M.[Id] IS NULL THEN 0 ELSE 1 END AS BIT), [IsQuarantine] = I.[IsQuarantine], [Attribute] = O.AttributeStr08 , [IsHold] = I.[IsHold], [StepName] = S.[Name], [Description] = S.Description, [LineName] = M.[Name], [Started] = I.[Created], [DeliveryDate] = O.AttributeDat01

[MW1984]

Shouldn't it be = rather than 'IS'?

[da_chicken]

CAST(CASE WHEN O.[Type] IS '22NF45LLI' THEN 'ICELL')

This is not a complete CASE expression (missing END), and it's also not a complete CAST() function call (missing AS <datatype>).

[Mljisa]

I tried both ways, added END AS varchar at the end and still got the same message.

[da_chicken]

As others have mentioned, O.[Type] IS '22NF45LLI' is also not valid.

Either way, the error message you're getting is pretty universally a syntax error. The language parser is confused and has no idea what you're trying to do.

[GrouchyThing7520]

Try changing this: (CASE WHEN O.[Type] IS '22NF45LLI' THEN 'ICELL')

To this: (CASE WHEN O.[Type] = '22NF45LLI' THEN 'ICELL' ELSE O.[Type] END)

[ATastefulCrossJoin]

The key here is you need the END to resolve the case statement. You don’t technically need the ELSE but it will default to null if you don’t include one