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]
