This table shows the Microsoft® SQL Server™ equivalent function for each Microsoft Access function.
Access | SQL Server |
---|---|
cint(x) | convert(smallint,x) |
clng(x) | convert(int,x) |
csng(x) | convert(real,x) |
cdbl(x) | convert(float,x) |
cstr(x) | convert(varchar,x) |
ccur(x) | convert(money,x) |
cvdate(x) | convert(datetime,x) |