Hi Guys,
what's the best way to do a search for first and last names including
whitespace? eg.
"jonathan fleming" or "*atha emin* or "*jona* *eming*" etc, etc.
I'm using qualifiers in an EOModel fetchSpec and have tested this in DBEdit
which works fine if I include a whiteSpace column in the db but that seems
like i'm overdoing it:
(firstName LIKE "*jona*" AND lastName LIKE "*eming*") works but no space
(firstName LIKE "*jona*" AND whiteSpace=' ' AND lastName LIKE "*eming*")
works too but a column for this can't be right
So what's the best way to get what I'm after here?
TIA
Jonathan :^)
_________________________________________________________________
Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
