>Hi all,
>
>I have the following:
>
>SELECT a.*,b.company FROM a LEFT JOIN b on a.fld1=b.fld1 ;
> WHERE company like ?findcompany
>
>I would like to include records with company=null if findcompany is empty, how can i achieve it?
>
>Thanks in advance...
SELECT a.*,b.company FROM a LEFT JOIN b on a.fld1=b.fld1 ;
WHERE company like ?findcompany OR 1=?IIF(EMPTY(findcompany),1,0) AND company is null