In my database I have some links set up that show various companies sorted by what their starting letter is, ie.

A, B, C

The problem I'm running into is that some companies start with numbers so of course they wouldn't appear in any of these link results. Is there a way to solve this? Can I have them all displayed at the top of the "A" section?

I've solved it thanks to this on the DBMAN FAQ site:


Question:

I have a field with 6 different possibilities: A, B, C, D, E, F.

How can I make a search where I can view all data corresponding to A or B or E in that field. So how can I search the db with an 'or' statement ?

Response:

Enter: A|B|E

in the search field on the form and check the "Regular Expression" checkbox.