title: SQL Server 2008 password ending in a semicolon
body: <p>Let's say I have a password that looks like this:  password;</p>
  
  <p>How can I get it to work with a semicolon as the last character.  The password works in SSMS and ODBC, but not with the connection string.  I've tried <code>&amp;quot;</code> around it but that does not seem to work.</p>
  
  <pre><code>&lt;add name="DbConn" connectionString="Data Source=LOCALHOST;Database=MYDB;Trusted_Connection=no;User Id=myuser;Password=password;" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>This is for an ASP.NET web application.  As far as I can tell, it is impossible.  UPDATE:  It IS possible!</p>