CREATE TABLE temp( Template M ) INSERT INTO temp( Template ) values([<html><body>Name: %%NAME%%<br>Address: %%CITY%%</body></html>]) replace Template WITH STRTRAN( Template, '%%NAME%%', 'John Smith') replace Template WITH STRTRAN( Template, '%%CITY%%', 'Atlanta, GA')