SELECT * FROM ...

[Anon]

I got field names 'Nov 03 01' 'Nov 04 01' 'Nov 05 01' 'Dec 06 01' e.t.c I want to to select all field containing Nov or Dec

I tried this syntah, but it doesn`t work

SELECT * FROM 2001 where date='Nov'

[whizkid]

Hi,

Try this:
SELECT * FROM 2001 WHERE date LIKE '%Nov%' OR date LIKE '%Dec%'

firemouse2001

[Anon]

Thanks, It works.