Problem with Like statement

[ZOR]

There is a field in the table which should contain a single name of a person, however the table has been filled with so many permutations in this field, that its a real headache as to how I can construct a like statement.

DONATO, Spain, red t-shirt, DIMITRI
DONATO, Spain, red t-shirt, number 10
DONATO, Spain, red t-shirt, number10, DIMITRI

Above is shown three records as an example. I had to construct a like statement which included a Left$,26 statement in order to retrieve all the DONATO records in the query.

However, in my query I am trying to find and individuals name, therfore my using a trim would never find the records with DIMITRI in them.

How do I get over the problem? Many thanks

 

[BNPMike]

ZOR

I personally can't understand your question. The data you have given is not relational so SQL is going to struggle a bit. Can you tell us a bit more about how the data is stored and why there are different numbers of fields in each record and finally a rough SQL statement of what you want to do?

 

[lespaul]

WHERE FieldName LIKE "*DONATO*" or FieldName Like "*DIMITRI*"

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins