Hey guys,

I have a problem and i couldn´t solve it with an elegant solution.

One stupid but representative example is:

from Parent p where p.name in (select c.parent_name from Children c where c.name='John')

Another example would be:

from Parent p where exists (from Children c where p.name = c.parent_name)

This is ok... but.. If my subquery returns parent's name containing or not a family name, but the p.name field contains only the first name ?

How can i match them ? Is it possible to use wildcards in this situation ?

Thanks for your time and attention.

T.H.