Values with apostrophe are truncated

[whatever]

I have an issue where I pull values from a database. The values have apostrophe's in them but when they are displayed on the page the string stops at the apostrophe (i.e. today's is displayed as today).How can I get the entire string to be displayed?Here is where I am displaying the string:Code:\[code\]<h1 class='tabletitle'><%=rs("FloorName")%> & nbsp;(<%=dspLayoutName%>)</h1>\[/code\]The variable containing the apostrophe is "dspLayoutName". It can come from either a DB or passed to the page. I am using asp classic.