wildcard char

[false420]

is there any wildcard characters in asp like :
if i want to choose a date from the database without concern of year is there a way to look past the year like this
say i want all 4/22/ but in the db its always
4/22/2005 or 4/22/2004 i want to pull with with year but without concern in the statement. hoping for somehting like
4/22/200* is this possible one way or another

 

[PHV]

WHERE Month(theDate)=4 AND Day(theDate)=22

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[false420]

acutally there is another way i need to do it, im gonna try to parse this stuff. what i need to change is the day. it is stored in avariable and passed page to page. i need to get in and do somehting like change 4/1/2005 to 4/22/2005. any ideas.

 

[false420]

like a date or string function