create table tablen([day] datetime,value varchar(20)) insert into tablen select '2007-1-1',1 union all select '2007-1-2',1 union all select '2007-1-3',2 union all select '2007-1-4',3 union all select '2007-1-5',4 union all select '2007-1-6',5 union all select '2007-1-7',6 union all select '2007-1-8',7 union all select '2007-1-9',8 union all select '2007-2-10',210 goselect * from tablen where day([day])%2=1
create table tablen([day] datetime,value varchar(20))
insert into tablen select '2007-1-1',1
union all select '2007-1-2',1
union all select '2007-1-3',2
union all select '2007-1-4',3
union all select '2007-1-5',4
union all select '2007-1-6',5
union all select '2007-1-7',6
union all select '2007-1-8',7
union all select '2007-1-9',8
union all select '2007-2-10',210
goselect * from tablen where day([day])%2=1