>>>>How to put logical into text? I forgot, sorry to ask. (sample: text+STR(numeric)+STR(logical)?)
>>>>
>>>>Chuck
>>>
>>>Transform() will do it. However, unlike Bill's suggestion, this gives you the periods around the value and you may not want this.
>>
>>And better yet, with Bill's suggestion you can return any value for the logical you want. IE .t. = "Yes" .f. = "No" or .t. = "True" .f. = "False" etc.
>
>Look at the transform function and its codes. trasnform(lLogical,"Y") will return "Y"/"N"
That still doesn't give you the control of IIF. With IFF I can give anything out based on the logical input.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc