Sorry... CreateODBCDate() is a ColdFusion function. Ken Moore wrote: > Hi Minh Lee Goon > > I'm still not certain what you are trying to do. > > Assuming that CreateODBCDate is defined by you somewhere else, drop the > #. Example: > SELECT MyDate > FROM ThisTable;