>Hi,
>
>I have many places in my app where I use the following expression in the WHERE clause of the SQL Select. It works but what bothers me is that the expression has DTOC() and then CTOD(). I convert a date to a character and then convert the character back to date. Can it be simplified? Here is the expression:
>
>"MYTABLE.DATE_FLD >= CTOD('" + DTOC( dDateValue ) + "')"
>>
>TIA
What's wrong with
MYTABLE.DATE_FLD >= dDateValue
Just make sure that dDateValue variable is in scope.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
