Hi, I am trying to get records from a database within a date range something like 1834-1835. I have written a simple query like "Select * from db where date between 1834 and 1835;"
But, the problem is that the date field is not consistent in the database, the records have dates like April 5, 1835; 1835; April 1835; Apr 1835 etc. Is there a way I can use 'like' and 'between' in my query to get all the dates between 1834 and 1835 however the date is formatted? I would like to combine the queries Select * from db where date like '%1834%'; and Select * from db where date between '1834' and '1835'' Is there a way to do this? Thanks in advance. Anitha ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.