Information générale
Catégorie:
Codage, syntaxe et commandes
>>>I'm trying to do an SQL that searches for whole words only, using the '%'...
>>>myfield LIKE "% FORD%" OR
>>>myfield LIKE "% FORD %" OR
>>>myfield LIKE "%FORD "...which correctly gets
>>>
>>>FORD MOTORS
>>>DIXON FORD
>>>BIG FORD CO
>>>
>>>but also BUFORD TIRES and CITY OF FORDHAM, which I don't want.
>>>
>>>Any ideas on how to do this? Or a better technique?
>>
>>LEFT(myfield,4) = "FORD" OR ;
>>RIGHT(myfield,4) = "FORD" OR ;
>>" FORD "$myfield
>
>Thanks...that's what I needed, a fresh perspective.
Bruce,
If you need to do alot of this, why not also try loking at Phd.. A package that allows you to di indexing/searching on strings in dbf's..
Thanx!
Tony Miller
Vancouver, Wa
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement