As it turns out, LIKE is a lot smarter than I thought, e.g. this works:
WHERE FLAGS LIKE '% % 1 %'
As long as there are at least 3 blanks in each FLAGS value. I suspect that it would also find records where the 4th word was '1', but that will not be possible in my situation.
-R.
David Morel wrote:
Le mer 15/09/2004 à 00:43, Peter a écrit :
Rod Dav4is wrote:
'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O)Don't hesitate to contact customer services to arrange for your 30day no quibble refund. :-Þ
THAT whas low. Actually, you could search the list archive, somebody
already wrote such an extension, with astonishing results in terms of
speed. I don't remember, I think it was 6 or 8 months ago.
-- Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 / USA Genealogy, et Cetera: http://freepages.rootsweb.com/~dav4is/ 391 ancestral & collateral families, mostly 17th - 19th century New England & European roots, total population: 89,400+ Annex: http://www.gencircles.com/users/dav4is/ email: [EMAIL PROTECTED]