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) |