title: How to remove double byte space from string in sql
body: <p>I have a column in database table that holds Item Numbers. One of the item contains double byte space <code>**400-000361（SZ17-20)**</code>. When this item's details is exported from system, it removes this space in csv and shows Item Number like this <code>**400-000361(SZ17-20)**</code></p>
  <p>When I try to compare the exported data with the system's data using query it does not list this item because the number is now updated.
  Is there any way I can ignore that double space character to get the matched item using Regular Expression or some other way ?
  I tried following way but it does not work</p>
  <pre><code>SELECT REGEXP_REPLACE('400-000361（SZ17-20)', '\s{2,}', ' ') T FROM dual 
  WHERE '400-000361(SZ17-20)' = TRIM(REGEXP_REPLACE('400-000361（SZ17-20)', '([[:space:]]{2,}|[[:cntrl:]])', ' '))
  </code></pre>