Primoz,

> Should bottom queries do the same thing ?
>
> select * from table where field like '%text%'
>
> select * from table where field containing 'text'
>
> Is any approach faster then another ?

Beside the fact that these methods produce different results (like
searches case sensitive whereas containing doesn't; so containing is
equivalent to UPPER(FIELD) LIKE '%TEXT%'), like will be faster if the
search field is indexed and can the search expression can be substitued
by a STARTING WITH (ie you do a LIKE 'text%').

Regards
Luc.