Re: Access SQL to convert string to number

  • Thread starter Thread starter LeAnne
  • Start date Start date
Cint is a VBA function that works if you are building a
query string in VB, or doing a query in Access/Jet, but
is not recognized by T-SQL which SQL Server uses. You
need to use Cast or Convert- SELECT....FROM....WHERE
NumField = Cast('5' as int).
Search Book online for more details.
HTH
Ben
 
Back
Top