T.J.Farrell writes:
> 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 you're comparing ~~ with LIKE then there's no difference at all. (Only
the extra cycles to
http://loveline.lip.st/ho.htm
gwx
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...
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).
Does anyone know if there is an equivalent statement to SQL Servers select
@@Identity?
