>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.