>>>Hi. Sorry this is such a stupid question < g > but I've looked all through VFP help and can't find
>>>the answer.
>>>
>>>How do you designate an integer constant?!
>>>(Like ldDate = {} or lyMoney = $0).
>>
>>Not a stupid question at all. The consensus seems to be that you need to create a table with integer
>fields and then UNION it in with the rest of the SELECT.
>
>Ouch. I was afraid of that. I've used a similar trick to get an empty memo field into a SQL SELECT result.
>
>For that to work with a view definition, the table with the integer field would have to exist permanently.

I had missed that that was a view definition question, but I still can't come up with a better way to do it. While you're at it, create all the other field types, so you'll be set across the board. :-)