Re: Subquery variants returning impossible(?) results

Douglas Wilson wrote: > > but your > second 'Where' clause filters out null values, and so eliminates > confusing results. > OK. it doesn't definitively eliminate null values, but perhaps none exist in hlp_program where hlp_module matches "zz*". But just to be sure about this query you could add "and hlp_program is not null". > > (select trim(hlp_module) || trim(hlp_program) > > from stxhelpd > > where hlp_module matches "zz*" > > ) Good Luck, Douglas Wilson