SHARE
TWEET

Untitled

a guest Jul 24th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT C, REGEXP_REPLACE(C,'(s+S*d+s*$)',',1')    
  2. FROM TABLE(                                            
  3.     VALUES                                              
  4.      ('VIA MILANO 123     '),                          
  5.      ('VIA MILANO A123    '),                          
  6.      ('VIA 11 MILANO AA123')                            
  7.            ) AS T(C)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top