Lynn,

Sorry I did not reply to reply to your response. Your answer worked great. I responded to the other answer, because it did not make since...

Jerry,

I do not understand why I would want to do something in three lines that I can do in one. My time statement seems much more efficient. ...

I come from the oracle world and to me this was too easy. If you have a variable that is 10 character in length as your input variable, and...