pulling certain records using links

[scatchon]

ok, here's where i am.

I have a page with a query that pulls all the records from my db and displays them accordingly.

What I'd like to do is have alphabetical links ( a - b - c - d - e -etc) and have only the specific letter records be returned.
For example, if someone clicks on the 'a' link it would display the businesses that names starts with an 'a' (and so on).

I know I can do this by creating 26 individual pages, but I'm sure there is an easier way to do this using something for the links and replacing the query with that 'something'.

any help would be greatly appreciated.

[marian]

yeah you can use the same page and pass value="a" or "b" at the url.

get that value from the url, and do something like this in your query.

select from table where something like 'a%'
select from table where something like 'b%'
select * from table where something like 'c%'

etc

[scatchon]

how would i pass the value?

and what would the code be for it and for the sql command?