title: How do I use Char(39) in a sql statement where clause?
body: <p>I am using SQL Server 2008 R2.  I am trying to create a recordset based off a sql statement.  In the <code>WHERE</code> clause is <code>'INTERNATIONAL PEOPLE' + Char(39) + 'S'</code>. So the single quote makes it PEOPLE'S.  This is failing.  From research it seems this should not fail.  Any help would be great. Thanks</p>