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:

<h1 class='tabletitle'><%=rs("FloorName")%>&nbsp;(<%=dspLayoutName%>)</h1>
Thanks for your help.