Re: search in alphabetical order

[Brian Brodsky <brianbrodsky@xxxxxxxxxxxxx>]

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]