Hi. Rob Kirkbride wrote: > I've googled around for this but can't see a decent way of doing this : > > I've got a persons name which is being stored say in 3 columns :- > Title, Forename_1, Forename_2, Surname. I want to allow a search say for > 'John Smith'. Problem is I can't just break it up into forename and > surname because I won't also know. > Is there a way to do something like a > 'select * where forename_1,forename_2,surname like '%String%' ?? > > Thanks for any help. Apologies if its a FAQ.
SELECT * FROM table WHERE forename_1 || ' ' || forename_2 || ' ' || surname LIKE '%String%'; -- Digitally Yours, Ian Johannesen web: http://perlpimp.dk/ msn: [EMAIL PROTECTED] cel: +45 31 13 73 76
smime.p7s
Description: S/MIME Cryptographic Signature
