At 04:33 AM 15/11/2008, you wrote:

>I have a simple sql statement:
>
>select
>sum(paritypos)
>from ParityEx
>where BeginParityDate between '2007/12/01' and '2008/11/30'
>
>It takes 400 mseg for 6000 records.

See Set's comments - fix up your wizard so that it doesn't inject spurious search arguments.

I'm just curious to know how your date literal format managed to get through without an exception...

./heLen