SQL 1

[jtgurkin]

I need to pull the following SQL statement from an MSAccess DB. It doesn't work as I have it written, how can I fix it?

SELECT * FROM Addresses WHERE Years CONTAINS 2004

Years

is a string field with a series of years seperated by semicolons like this "2000;2001;2002;2003;2004"

 

[Veep]

The wildcard character for Access is *. So, you need to make the database engine see something like:
SELECT * FROM Addresses WHERE Years Like *2004*

Bottom line is that you really need to redesign your table.

 

[jtgurkin]

How would you reccomend I redesign this? The list is the particular years a person participated in this group. They aren't usually consecutive, it's more like 1998; 2000; 2001; 2003