title: How to remove special characters from the string in sybase using patindex
body: <p>i am having data wich consists of special characters but my output should not display that special characters or ascii characters . I need only alphanumerics and spaces allother character should be replaced with null . Please suggest some way to handle this i came to know patindex will work fine but i am not sure whether it will replaces multiple characters from a string </p>
  
  <pre><code>declare @a char
  select @a = 'tHo mas@fi5.com'
  
  my output should be tHo masfi5com
  </code></pre>