assign empty to a date field

R17 · Dec 21, 2003

how do i assign empty records to a date field using select - sql?

i tried select {^ / / } as mydate, but i'm getting an error.

any help?

TIA

R17 · Dec 21, 2003

got it, i used {} to create an empty date field.

ramani · Dec 21, 2003

HI

SELECT {} AS myDate, * FROM myTable......

____________________________________________
ramani - (Subramanian.G)

When you ask VFP questions, please add VFP version.

Mike Gagnon · Dec 22, 2003

R17

To add to Ramani's suggestion this also works

Code:

SELECT CTOD('') as myDate,* from MyTable...

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.