Jaime,

Do it SQL way, use LIKE operator.

select * from mytable where field1 LIKE "%" + ?Par1 + "%" and Field2 LIKE "%" + ?Par2 + "%"

>I am trying to build a parameterized view based on some fields using the $ operator, but i cannot get the whole set when i use empty strings...
>I am trying:

>store "" to Par1, Par2
>sele * from my table where ?Par1 $ field1 and ?Par2 $ Field2
>

>The above always gives me an empty cursor. I tested, and ""$field1 always returns false, so how can i achieve what i want?