Click to See Complete Forum and Search --> : CAST Function in Access


Terrorke
07-28-2006, 07:09 AM
Hi everybody,

This may be a simple question to most of you, but does anybody know the function in Access for CAST?

Thanks in advance

russell
07-29-2006, 09:51 AM
Cint -- cast to ineger
Clng -- long
Cdbl -- double
Csng - single
Cstr - string
Cbool - boolean

SELECT clng(fieldName) FROM tableName