Re: Searching for partial dates

Is the date really stored as an integer? You say so, but then you're trying a wildcard (i.e. char) search. If so, try this (pretending date_int is your date stored as an integer column in the table large_table):

Re: Searching for partial dates

From: jeff <[EMAIL PROTECTED]> > I need to be able to search by partial dates. > What is the best way to search? You ~could~ do something harsh like: SELECT *, substring(myDate, 1, 2) as month FROM myFunnyTable WHERE month = '06' But unless you are only going to need this data