Hi all!
I am writing a CASE statement in the Reportsmith software to 'rename' or 'update' field values...see below
CASE (LOC.LOCATION) WHEN 'C07' THEN 'NRG' ELSE 0 END
it is returning the following:
Syntax error converting varchar value 'NRG' to a column of data type int.
What does this mean and how can I fix?
Any assistance or guidance is appreciated.
~jg
I am writing a CASE statement in the Reportsmith software to 'rename' or 'update' field values...see below
CASE (LOC.LOCATION) WHEN 'C07' THEN 'NRG' ELSE 0 END
it is returning the following:
Syntax error converting varchar value 'NRG' to a column of data type int.
What does this mean and how can I fix?
Any assistance or guidance is appreciated.
~jg