I'd strongly suggest you do this on the client side. SQL isn't geared towards manipulating strings.
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]