Worked like a charm...simple, quick and effective...Thanks again for your help!!!

Thanks Andrew!! I'll work with your suggestion...definitely never even occurred to me to go that route which is what is so great about places like this...Sometimes a good educated set...

Andrew...that's correct...Sorry forgot to include that I'll be updating two pieces of info/data the users birth month and birth day as two separate fields....I'd love to say this is a...

I had tried utilzing REVERSE() with stuff but for whatever reason I guess I wasn't utilizing it correctly as I never got teh results I was after...but thank for the...

I've used the STUFF function numerous times in the past but just couldn't wrap my mind around how to work it in this case....I've always dealth with strings and worked...

Thank you both very much for your help with my issue!! 😀

Great! Thank you very much for your help!!

That did the trick....thank you very much for the insight!!!

I did some follow up reading on the begin and commit tran statements and I think I understand better now why...