varchar to integer

[Tseug]

Hello!  I have the following in a Query Calculation:

Code Select Expand

if ([Q9] > 0) then (1) else (0)

which gives me the following error:

Code Select Expand

UDA-SQL-0460 A general exception has occurred during local processing.
UDA-EE-0094 The operation "greater" is invalid for the following combination of data types: "varchar" and "integer"

I'm unable to find a way to change the value of [Q9] to an integer ([Q9] is pulled from a .csv file).  I'd appreciate any and all suggestions.

Thanks! ;)

[matsau]

hi,
you can probably use function cast([Q9], integer). just make sure that this function is supported.