[sqlite] Getting row number in a sorted list.

[Anthrathodiyil, Sabeel (S.)]

Hi,

I have a database with NameTable having name records in it, I need to get the 
row number of the first record in the sorted list of names for which the search 
name matches.

Example, for below entries in NameTable

Name

1.       PTN

2.       ABCD

3.       CDE

4.       PQRS

5.       AXN


I want to get the row number of the first name that starts with 'P' in the 
sorted list. Here it's going to be row number 4 (PQRS)in the sorted list.

I need the row number, not the entry itself for my use case. How do I form a 
query to achieve this?

Thanks,
Sabeel