How to generate a group of file names in SQL?

Question

Hello all -
I have serveral staff members that have certain file names associated to their titles. We have to have these file names specific per employee...... Example: beth has file names = beth100 - beth400.
If I were to create a windows application (vb.net 2008 pro) with 2 text boxes that I could input beth100 in one and beth400 in the other how would I create the database to generate all the file names (sql 2005 express - I believe that's what comes with vb.net 2008 pro).
In other words, I need an entry into the database that will be:
beth100, beth101, beth102, beth103 and so forth.

_____________Edited Part___________

forgot to mention I will be using visual basic for the code.

Hope this is understandable.

Thanks in advanced
daveofgv

John Arcadella · Answer

That should be easy. Use For look and loop from 100 to 400. Something like this in psuedo code. Dim counter as Integer Dim fileName as string For counter = 100 to 400 fileName = beth + counter.ToString() ' Save file name Next