Subject CONTAINING magic keyword
Author csswa
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.

Andrew Ferguson
-- Who died and made me king?