SELECT * FROM test WHERE SUBSTRING(convert(varchar,cdate,140),1,10) BETWEEN '2011-04-11' AND '2011-04-15'