fabiano@... wrote:

>
> And what is the problem with this?
>
> select ...
> where ( :name like '*' or name like :name )
>

Wouldn't "select where :name = '%' || :name || '%' "
with setting :name = '' prior to the Query when the user
types in '*' and Clear the Query when the user enters ''
to show now results, achieve what you wanted ?