db search with dates

[crashc123]

I want to do a search of all fields of db, how would you do that with dates?

Say if someone typed in a "12" I want it to search all the text fields and date fields then show all records that have it in the fields. "12" could day or month or even part of the year

Something like

strSQL = "SELECT textfield, datefield FROM mytable "_
& "WHERE textfield LIKE '%" & Replace(strSearch, "'", "''&quot & "%" _
'here's the problem I have no idea how to do this
& "OR "Cstr("datefield&quot" LIKE '%" & Replace(strSearch, "'", "''&quot & "%"


?????
Microsoft VBScript compilation (0x800A0400)
Expected statement

I would appreciate any help

 

[Jonax]

I guess I would cast/convert (depending on the dbms' syntax) the datefield into a char and then use LIKE %%
...
Are you using SQL-server, Access, something else? This is not a bug - it's an undocumented feature...
;-)

 

[crashc123]

I am using an Access DB. How would I connvert it? Before the sql state or in the middle.
Please give an example.

Thanks

Sonya