TO_NUMBER conversion

  • Thread starter Thread starter Craig Bender
  • Start date Start date
C

Craig Bender

I have a query where I want to do a SELECT and ORDER BY a TEXT field that
actually holds numerics in it and have it order by in a numeric fashion. On
other SQL platforms I would type by SELECT statement and then do "ORDER BY
TO_NUMBER(id_in_txt_field)"

Therefore the sort would be:
1
2
10
NOT
1
10
2
But apparently Access2000 does not know about the standard TO_NUMBER
conversion function. How is this simple query doe on Access?

Thanks,
Craig.
 
AFAIK, the TO_NUMBER function comes from Oracle. In Access, use the Val()
function.
 
Back
Top