Thanks all, I got it figured out googling it. I am a
developer, so the logic I get, it's more or less the syntax changes
that I am trying to pick up on. It's an inherited application that
had to have mods made to it, and they needed them implemented asap.
So, I was just hoping for a push in the right direction, and google
helped. 🙂
In case anyone else has the same issue, I did indeed use the
right(), left(), mid() functions