> use: where name like '%names%'
Except that the user specified he wanted to be able to find Tom Jones
and jonas from the search text jon, so you either need to use:
where lower(name) like ('%' ¦¦ lower(searchtext) ¦¦ '%')
or something similar, which is slow unless you have an index on
lower(name), and even then.
Or you use the regexp search ~* given previously.
----------------------------------------------------------------------
----------------
Moray.McConnachie@computing-services.oxford.ac.uk