[ ] with LIKE not working in WHERE clause

[Techno]

I don't know what mistake I am doing but here is the scenario-



SELECT * FROM Table3
WHERE Column2 LIKE '[a-d]';

Column2 has a,b,c,d,e,f

is fetching no records. I have tried using both capital and small letters but it's not working.
Ideally it should fetch records where Column2 is a,b,c,d.

[Bob Fitz]

Try:

SELECT Table3.Column2
FROM Table3
WHERE (((Table3.Column2)>="a" And (Table3.Column2)<="d"""));

Or even:

SELECT Table3.Column2FROM Table3
WHERE (((Table3.Column2) Between "A" And "D"));

[Micron]

Not clear what you mean.

Column2 has a,b,c,d,e,f

All of those characters can be in one record or any record may contain one or more of them? If all in one record then even >="a" And <="g" will return a to f if it's all one string.

[Micron]

Returning to my shop now so will suggest that if the field looks like

Descr
a,b
b,e
e
g

then maybe what you want is Like '[a-f]*'

[Techno]

Thank Bob, your queries worked.
And Thanks Micron, actually the values are individual letters to signify a group name, so "a" in a row and then "b".

Wondering if [] are not supported in Access, as Bob suggested BETWEEN worked perfectly.

[Micron]

Wondering if [] are not supported in Access

I gave you a working example of using [].
The data

Descr
a,b
b,e
e
g

The result

Descr
a,b
b,e
e

The wild card returns single value records as well as multiple so works either way.
Since your records only contain single values:
New data

Descr
a
b
e
g

New results (using only Like '[a-f]' so no wild card)

Descr
a
b
e

There must be something different about your data if neither of them work for you. If you want that investigated post a zipped copy of your db.