Migrating Conversion Functions from Access to SQL Server

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)

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.