title: Encrypt / decrypt data in SQL Server Management Studio
body: <p>I need to store sensitive data in SQL server and need this encrypting.  This ideally needs encryping and descrypting within SQL server and not in the code of the application(s).  The reason being, the application to add the data to the database will be written by someone else in ASP and I will be pulling out this data and using this within my application which is written in PHP and will therefore need this decryping.  </p>
  
  <p>MySQL has a nice little function AES_ENCRYPT but I cannot find anythign similar for MSSQL and I am very unfamiliar with MSSQL, so any help would be much appreciated.</p>