[..] > date. Open up the SQL Books Online and type in "datetime data type, > formats" on the Index page. See also "SET DATEFORMAT" Thanks, good tip. I've never used Books Online before. > Are you getting errors? I *was* :) Thanks for your assistance. Regards Chris Marsh