[SQL] Update table: extract max(hour).

Hello, I am trying to update one table based on another table data as follows: TableStatus containts fields date (date), hour (time), IDcode (text), status (text). TableProduct contains fields state (text), datestate (date), IDcode (text).

[SQL] LIKE vrs ~~

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...