Thanks for the input everyone. The C# solution sounds nice but I know I can do it in VBscript which I have more experience with so I'll probably go with that. I was just wondering if there was some way to do this natively in SQL.