Is there a way to use a short date format in a query?  For example

SELECT * FROM Jobs WHERE JobDate > 1/1/08

Scott


The sensible answer - Nope all dates have to be expressed in ANSI format

The silly to stupid answer - YES. All you have to do is format the column appropriately eg

CAST(SUBSTR(JobDate,1,POS('/',CAST(JobDate AS VARCHAR)+'/'+etc etc

or something like that

Roy Lambert [Team Elevate]