Converting Data Types

[oldduffer]

All

Does anyonw know if it is possible to convert the data type of a field from within a query. I have a char field (on the MSSQL7 database at the other end) and want to convert this into a numeric. Access wont allow me to perform a CONVERT(numeric, <fieldname>) as this is apparently not a recognised function. The database is connected through a link table.


SELECT x, y, convert(numeric, z)
FROM alphabet
WHERE x = &quot;blahblahblah&quot;


Yours Stumped

Old Goat

 

[AWithers]

try cdbl(z) to convert to a double precision number

cint(z) to an integer

Andy

 

[nabiS2K]

Have you tried the Val function. What kind of data is in the char field? God Bless
Mike ;-)