Hi all,

I have two tables which I need to join them over containing condition.

This command doesn't join the tables using that condition:

select a.*, b.*
from zzz_ukony a
left join zzz_doc b on b.filename containing a.cs||'.';

but for test these commands work fine and return what I am looking for:

select * from zzz_doc where filename containing '30017003.';
select * from zzz_ukony where cs containing '30017003';

What could be a problem?

Firebird 2.1.4 Windows

Thanks for any idea in advance.

--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk