SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

16Oct/06Off

SQL: Remove Strings or Letters


Remove:

select TRANSLATE('12A3','0123456789', ' ') FROM dual

or

 

select
 LTRIM(RTRIM(TRANSLATE(UPPER('12a'), ABCDEFGHIJKLMNOPQRSTUVWXYZ', ' '))) as nr
, LTRIM(RTRIM(TRANSLATE(UPPER('12a'),'0123456789', ' '))) as nr_add
from dual

 

 

Tagged as: , , , , , , , , , , Continue reading
   
Custom Search

Recent Posts

Tags

Abstract Als Amp Carpal Tunnel Syndrome Cast Application Chf Compendium Computer Mouse Der Schweiz Deutschland Ein Fiat Fiat Ulysse Google Google Maps Hotels Ins Kriterien legoland Legoland Park Lt Mail Medical History Mit Nun oracle Oracle 7 Oracle Database Oracle Forms Oracle Sql Oracle Toad Peugeot Photo Credit Php Pl Sql Repetitive Strain Injury RSI Schweiz Solution Number Sql Code Switzerland Toad Toad Oracle Wikipedia Wrist Pain

Recent Comments

Categories

Blogroll