Clng -- long
Cdbl -- doubleCsng - 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
原文链接：https://www.f2er.com/vb/260857.html