DECLARE @Str varchar(16), @dt datetime SET @str = '22/02/2003 14:48' -- CONVERT SET @dt = CONVERT(datetime, @str, 103) -- SET DATEFORMAT SET DATEFORMAT dmy SET @dt = CAST(@str AS datetime) -- Restore DATEFORMAT SET DATEFORMAT mdy -- or whatever defaul it is>Dear friends,