Query on a query ... :P

Hi,

I have a table capturing a few details including record insertion date (inserteddate) and a text field (attachuserfile) containing the date + a filename (eg. “200710251210abc.doc”).

More or less, the date values present in these 2 fields will be almost the same; just that in a few occasions alone, the attachuserfile date may precede the date value in inserteddate.

I need to perform search on date to retreive records, which of these is a better option in each case:

case 1: when a from-to date is given:
- search using “between” on inserteddate
- is there way to search to search this text field attacheuserfile for giving the same result?

case 2: when a particular date is given:
- search using "=" on inserteddate
- search using "like" on attacheuserfile

Thanks in advance.

Regards,
Vidi

If you use sql server, you can:

Case 1: take substring of text column then convert it to datetime.

Case 2: what's data type of inserteddate? If it's datetime, need to some conversion as in case 1.