Subject | CONTAINING magic keyword |
---|---|
Author | csswa |
Post date | 2002-07-25T10:59:22Z |
BTW, am I the only one who had no idea about this command? I
stumbled across it just now in the manual. Previously I'd been using
the UPPER command to do my case-insensitive text parsing, ala:
if (upper(field) like '%MATCH%') then...
when all along I could have been doing:
if (field containing 'match') then...
or the more brazenly eccentric:
if (field containing 'MaTcH') then...
D'oh! Just thought I would mention that in case there is anyone out
there as SQL-challenged as me.
Regards,
Andrew Ferguson
-- Who died and made me king?
stumbled across it just now in the manual. Previously I'd been using
the UPPER command to do my case-insensitive text parsing, ala:
if (upper(field) like '%MATCH%') then...
when all along I could have been doing:
if (field containing 'match') then...
or the more brazenly eccentric:
if (field containing 'MaTcH') then...
D'oh! Just thought I would mention that in case there is anyone out
there as SQL-challenged as me.
Regards,
Andrew Ferguson
-- Who died and made me king?