<div>
In a single-quote delimited value (Line 3), you need 2 single-quotes to represent a single-quote:
<pre><code id="code-20-39799798-1">SET @MyText = 'he''s not &quot;very&quot; good'</code></pre>
</div>


In a single-quote delimited value (Line 3), you need 2 single-quotes to represent a single-quote:

SET @MyText = 'he''s not "very" good'

<div>
Hello and thank you....but the text in the database (entered by a user) has only single quote. &nbsp;I want to retrieve this text but I need to change the single quote to '&amp;#39;'<br />
<br />
?<br />
<br />
Thanks again,
</div>


Hello and thank you....but the text in the database (entered by a user) has only single quote.  I want to retrieve this text but I need to change the single quote to '&#39;'

?

Thanks again,

<div>
replace(replace(mytext,cha<wbr />r(34),'&amp;qu<wbr />ot;'),char<wbr />(39),'&amp;#39<wbr />')
</div>


replace(replace(mytext,char(34),'&quot;'),char(39),'&#39')

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I would like to create a function that will be passed in quite a lot of text and which will replace any single and/or double quotes with the html value for them. &nbsp;I have tried the code below but I get an error in compiling it....<br />
<br />
I am not sure what I am doing wrong. &nbsp;Any help would be much appreciated.<br />
<br />
Cheers,<br />
<br />

<pre><code id="code-10-28344961-1">DECLARE @X nvarchar(100)
DECLARE @MyText nvarchar(100)
SET @MyText = 'he's not &quot;very&quot; good'

SET @X = REPLACE(@MyText,'&quot;','&amp;quot;')
SET @X = REPLACE(@X,'''''','&amp;#39;')

PRINT @X</code></pre>
</div>
</div>


Hello,

I would like to create a function that will be passed in quite a lot of text and which will replace any single and/or double quotes with the html value for them.  I have tried the code below but I get an error in compiling it....

I am not sure what I am doing wrong.  Any help would be much appreciated.

Cheers,

(CODE)

Getting text from table with single and double quotes

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.