Hello,
To handle the INSERTED "#" marks into your Rich Editor Token, I would recommend passing this as the parameter to your Stored Procedure for your Rich Editor provided value:
replace('$(TextEditorShortName)', '#', '')
This SQL Statement will replace any found instances of '#' with ''.
It's true that a Single Quote can interfere with your stored procedure calls. So it may be important to replace or escape certain characters that can break your SQL Procedure call.
Take a look at this thread, they discuss how to escape a single quote:
http://stackoverflow.com/questions/...sql-server Another method may be to use SQL to replace single quotes with an HTML ASCII code of "'". This way you're storing this HTML code instead of the real single quote. You can always convert ' back to a single quote. You can learn about other ASCII Codes from here:
http://www.ascii.cl/htmlcodes.htm Please let me know if you have any questions.
Thanks,
Ryan