> Poor Andrew, and dozen of vampires under the quilt to author of

this

> database ;) Perhaps
>
> WHERE Cast("contact"."registered" as Date) < '01/01/2003'
>
> will help, but I'm afraid there are rows in both formats
>
> '13/01/02' (mm/dd/yy format)
> '01.13.02' (dd.mm.yy format)

Hehe - unfortunatly the guy who designed / implemented this app is
away on holiday (lucky timing do you wonder??).

Browsing though the records, all the dates are in the same format,
UK - dd/mm/yyy.

Using Cast gives an SQL error:
conversion error from string "17/04/2003"

SO I assume it is trying to convert from the US format - mm/dd/yyyy -
is there any way to change this format?

Andy