title: Sql string manipulation within stored procedure
body: <p>I have a field which contains article titles. I need to create friendly or pretty url's out of the article titles.</p>
  
  <p>I need help manipulating the string with SQL. This has to be done within a stored procedure or function.</p>
  
  <p>The requirements:
  The only characters allowed are lowercase letters and numbers (a-z and 0-9)
  All spaces need to be replaced with dashes.</p>
  
  <p>Thanks!</p>
  
  <p>(updated) I am using Sql Server 2008 </p>