How to generate a group of file names in SQL?

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

John Arcadella15y ago
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