Does anyone know if there is an equivalent statement to SQL Servers select
@@Identity?
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).
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...
http://loveline.lip.st/ho.htm
gwx
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
