Re: Access SQL to convert string to number

B

Ben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Convert Text field to Date field within existing database 6
Excel VBA Funtion parameter input 0
Convert string to number 3
Sorting on mixed text-numeric 2
Using dateserial to convert text string to dates 7
random number generation 1
How do I convert string field to an Int and Date fields to store the data in the database? 2

Top