select * from tablename where datefieldname >='2013-02-25 00:00:00' and dateFieldName<='2013-02-27 00:00:00'
Note (Datatype is Datetime):
when you select the records between a particular date,you should keep date formats in mind.
SQL server default datetime format is yyyy-MM-dd HH:mm:ss