In SQL sever 2008, when you use between the lower limit and the upper limit are inclusive in inclusive in the result.
create table #temp( id int primary key identity, name varchar(20) ) insert into #temp values('a') insert into #temp values('b') insert into #temp values('c') insert into #temp values('d') insert into #temp values('e') insert into #temp values('f') select * from #temp where id between 2 and 4
Note the result. The above query will include record with id=3 but 2 and 4 also.
Output
+----+------+ | id | name | +----+------+ | 2 | b | | 3 | c | | 4 | d | +----+------+