>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

HoldInt is N(1, 0).

For HoldText you can use

SPACE(nLengthYouNeed) AS HoldText

For an empty date you can use simply {}.