paging problem Search form

[eluser]dine[/eluser]
My problem is somewhat similar to post.

I am writing a custom query and using
$this->db->query($Sql);

now I need to do paging.

i am wondering what I need to write as limit in searching query. I means...for example
$Sql = "select * from abc limit startindex,lastindex"
Just ignore the error,syntax..
There is no restriction to use POST or GET Method.

Kindly let me know if you need to ask anything else more to reslove this prob.

thanks in advance