Use LIKE in your WHERE clause of your SELECT statement. In your example: SELECT * FROM table_name WHERE column_name LIKE 'A%' ORDER BY column_name On 3/23/2012 8:59 AM, vijaya lakshmi wrote: > > hi, > > Please guide me on how to code to search elements from database > in alphabetical order. > > If we click on A all items starting from A get displayed. > > -- > Thanks & Regards > VijayalakshmiPrasanna > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed]