sqlserver paging,searching and sorting

Question

Hi All, i have small doubt about a stored writing as a combination of paging,sorting and searching.
         For example i have 2 tables like
              users-user id,username,password,region id
              regions-regionid,region name

I am trying the stored procedure for searching and sorting.But i did not understand the paging.
   The stored proc having parameters like
                   colname,searchname,pageindex,pagesize.

Can any one help to solve this one?