I have a UNION statement I am working with and need to place hold fields that are used in the second SQL statement in the first.

I was adding assignment lines in #1 to the SQL such as....

Select ;
0 as holdint, ;
'' as holdtext, ; actually this is two double quotes
{//} as holddate, ;
0.00 as holdnum, ;

etc

Is the assignment of 0 in holdint set that field/variable to an integer or a numeric?

The holdtext apparently the #2 SQL is a field that is 30 characters long. I think this may be giving me a INCOMPATIBLE UNION error. I think I need to specify a length for this holder in #1 but not sure how. I thought about adding a LOCAL variable but again, not sure how to declare the length (other than typing 30 spaces which I don't like.)

Suggestions - help !!!!!!

Thanks