Thank You Stealth for your response. I am a beginner with SQL ..

I have a cold fusion search page with pull down menus each of which have a javascript running to populate the drop down menu. The javascripts select columns in the table to display records.I need to create another drop down menu which helps u search by DATE.And the table queried does not have a DATE column in it.

I could possibly query the table inserting the date column, is there another way to do it where I wouldnt have to alter the table at all?

Please help.

gasa

Nope...you need to insert a DATE field/column in that table. If you don't have a DATE field, how do you expect to find records with a DATE value? ;)
========================================
Buh Bye!

Cheers,
Me