> > > > > SQLWhereItems.Add('(Reading_Time > (Cast('2005/10/05' As
> > > Date)))');
> > > >
> > > > try
> > > > SQLWhereItems.Add('(Reading_Time > (Cast(''2005/10/05'' As
> > > Date)))');
> > > >
> > > Thanks for the reply Alan.
> >
> > you would get "column unknown" if you put double quotes around the
> date - I
> > want you to put 2 single quotes.
> > i.e. NOT "
> > but ''
> >
> > Alan
> >
> Thanks Alan, missed the two single apostophes vs. the double
> apostrophe. Now working fine. This construct is a little peculiar
> (at least to me).
> Thanks for the help.
> Tony
>

they are literals, single quotes inside your single quote string.
It's the same whenever you try to embed a single quote in a pascal string
which is also enclosed in a singel quotes.
You must have always beeen doing this...and never realised I suppose.
Alan