These type of string operations are better done at the client side in C#, VB.NET, Java, or any other high level language.  Using any variant of SQL to do such tasks would be quite onerous.

However, if this is a homework assignment and you need some assistance, please let me know and I would be glad to write up some tips on what SQL operations should be considered.

Steve Naidamast

Sr. Software Engineer