SQL that work on ORACLE and not work on DB2 : <p>I have an SQL that put the comma before house address number. 
This SQL work great on ORACLE but if I paste it in DB2 (vers. 7.2) 
is not work. </p>

<pre><code>SELECT C, REGEXP_REPLACE(C,'(\s+\S*\d+\s*$)',',\1')     
FROM TABLE(                                             
    VALUES                                              
     ('VIA MILANO 123     '),                           
     ('VIA MILANO A123    '),                           
     ('VIA 11 MILANO AA123')                            
           ) AS T(C)                 
</code></pre>

<p>Is there anybody that can tell me why ? or if I can convert it please ? </p>

<p>Thanks a lot 
Denis</p>
