help on a SQL query using CAST in SQR

[kosarajuuma]

Hi All,

I need to write the following SQL query in SQR:
select cast(@var as datetime)

I used the following statement:

begin-select
cast($var as datetime) &var
end-select

On executing the above, I get the following error:

(SQR 1303) Error in SQL (perhaps missing &name after expression):
SELECT cast(? as datetime)
(SQR 1304) Check SELECT columns, expressions and 'where' clause for syntax.

Please help me solve this!
Thanx and Regards,
Uma

 

[hutchkc]

i would also like to know if it can be done. several of us have tried doing something similar under custom sql. unsucessfull. eventually we gave up and had to modify the db table