select REPLACE(messagebody,'<p>','') from message
SELECT REPLACE (REPLACE(messagebody,'<p>',''), '</p>', '') FROM message
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)