sql query VAL function
Hello!
I have developed an application with Access database. The problem is with Access database at backend I developed a few queries having "VAL" function.
Like
select DUE_DATE from order_installment order by VAL(DUE_DATE) desc
It works fine with Access database. But when I convert my database to Sql Server the sql query does work and give an error at VAL function.
Is there anyone know, what is the replace of VAL function.
Thank you,
Zeeshan Ahmed
P.S: VAL function converts an integer value in TEXT data type field to Numeric
|
