I already read question [here is the link](https://stackoverflow.com/questions/25040509/how-to-use-limit-in-microsoft-sql-server-2008) about `LIMIT` in sql server and they say that i need to use `row_number()` `between` i already tried it and worked totally fine. But i need it like in Mysql using prepared statement like this:

```
   $user_input = $_POST['user_input'];
   $user_input = "".$user_input."%";
   $start = 0; 
   $limit = 20;
   $search_query = "SELECT * FROM item_master WHERE item_desc LIKE ? OR  item_number LIKE ? LIMIT (?,?)";
   $qry_search_query=$conn->select($search_query,array($user_input,$user_input,$start,$limit),'0126181431');

```

> 
> Here is the example code for Sql Server `between`
> 
> 
> 

```
select * from (select[UserId], [HomeTown], [HomepageUrl], [Signature], [CreateDate] , row_number() OVER (order by  [CreateDate]) as RowNumber form [UserProfiles]) Derived where RowNumber between 4 and 9

```

I tried to use `between(?,?)` but didnt worked.

Note: I add this `$dbh->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );` in my connection.php page in order to work prepared statement in Mysql. this is the reference: [Please click this link](https://stackoverflow.com/questions/10014147/limit-keyword-on-mysql-with-prepared-statement)

I tried prepared statement `between` in sql server 2008 and it doesnt work

I know this is sound weird but i should use sql server 2008 in my php application as database because of my current employer still using 2008 version not 2012 or later. Any idea guys?