A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ etc..... Navigate a Recordset?

[markvan]

I have a list of 300 names in a recordset
I want to put links at the top of the page like:
A | B | C | D | E | F | G | H | etc.....
So you can move to the names beginning with whichever letter you choose.
Can I target parts of a recordset? or am I missing the obvious, help please!
Is there some way like "B*" or "B%" to bring up the B's, if so where and how?

Any suggestions how to get this working would be much appreciated.

mark V X-)

 

[zakd]

You may need to use handcode.
Try to use "Left" it's a VBsript String Function. It returns how characters you want from left side of your string(in this case you database names)
Syntax
Left(string, length)

so you can compare your Letter with your Name (in the db)

 

[Guest_imported]

Depends on the Database you are using - I use mysql and a querry such as this -

Select * from TableName Where ColumnName = "B%"

There is more information at

http://www.mysql.com