Hi, Anyone know how to format an

[cleith]

Hi,

Anyone know how to format an SQL WHERE clause for FoxPro ODBC. I have tried several formats and all return 'missing operand error.

WHERE date = #01/01/2000#

WHERE date = '01-01-2000'

WHERE date = '2000-01-01'

WHERE date = '20000101'

Thanks,

Charles


I have

 

[cmpgeek]

what about this?

replog."RLG_DATE" >= {ts '2003-01-01 00:00:00.00')

good luck !

ShannonLea

"I keep hitting 'escape' but I'm still here..."