[SQL] LIKE vrs ~~

[T.J.Farrell]

Hello,

I was wondering about the performance incidence of :

            SELECT *  FROM table1 WHERE UPPER(field1) LIKE
UPPER('%thomas%');

versus:

            SELECT * FROM table1 WHERE field1 ~~ '%thomas%'

if any...