Hi,

You can use VAL(fieldname) function.


--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"TIML" , iletide þunu yazdý
...
I have the following SQL statement to pull in data from a database.
INVMASTER.StockCode and INVMASTER.ShelfLife are both strings. How do I
change each field from a string to a number in the SQL code, so that it
comes into the spreadsheet as a number instead of a string?

SELECT INVMASTER.StockCode, INVMASTER.ShelfLife
FROM dbo.INVMASTER INVMASTER