"T.J.Farrell" <[EMAIL PROTECTED]> 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%'
Of course "~~" is just an alternate spelling o
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
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...
