How to convert data (String) to Numeric in access query?

C

CyberBoyofUSA

I want to convert string data typt (i.e. "00000380") to numeric in access
query, not in VBA. it seems simple enough that there should be a key word
(i.e. INTEGER?) in access to do so. But I could not find any key word to
convert the data.
 
D

Dan Artuso

Hi,
CLng() is what you're looking for.
Keep in mind that you're going to lose the leading zeros.

You can also use CInt() if the numbers won't be higher than 32,000
 
Top