MS-ACCESS to SQL server help needed

• Vaibhav Shete

  Newbie

  Points: 7

  More actions

  February 11, 2005 at 12:13 am

  #65647

  I have a project to convert an application developed in VB 6.0 which has backend as MS-ACCESS and make it compatible with SQL-SERVER 2000. many fuctions like cdate(), IsNull() and UCase() which work in access do not work in SQL. what are their SQL Equivalent?

• DavidMcAfee

  SSC Eights!

  Points: 887

  More actions

  February 11, 2005 at 11:22 am

  #541858

  Cdate() is now Cast( yourvariable AS DATETIME) or you can also use CONVERT(YourVariable, DATETIME, 112)

  ISNULL() is ISNULL() in SQL too, but actually works like NZ() in access. ISNULL(SomeValue, ValueIfNull)

  UCASE() is UPPER() in SQL

  HTH

  David McAfee