>>
>>Try something like:
>>select proread.la_idla,desc1 = case usertab.us_type when 'IT' then usertab.us_desc else '' end,
>> desc2 = case usertab.us_type when 'RE' then usertab.us_desc else '' end
>> from proread, usertab
>> where proread.pr_inttype=usertab.us_code
>>HTH.
>
>This doesn't do what I need, but it will probably help. It's somehting for me to play with.
>
>Thanks,
>
>Pete
Yes you could add the 'IT' and 'RE' criteria to the WHERE clause so it only picks up those records. Otherwise, it picks up everything and you could conceivably have both fields blank (which isn't what you want).
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao