@rory: Sorry I was not clear that sometext could be anything; i.e. %sometext%, %hogwash%, '%palinka%'... So your proposed solution will not work.
@g: No need to use replace, I think your STUFF solution will work just fine. Thanks again!
Jared
CE - Microsoft