Clng -- long

Csng - single

Cstr - string

Cbool - boolean

==================

val() << cast to number,but it may be a vb function.. therefore,you can use vb function such as str().. to cast variable from one datatype to another..

example:

SELECT clng(fieldName) FROM tableName