sql query VAL function
I have developed an application with Access database. The problem is with Access database at backend I developed a few queries having "VAL" function.
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.
P.S: VAL function converts an integer value in TEXT data type field to Numeric