Re: SQL Question
From: martin.kunigkeit <martin.kunigkeit_at_metronet.de>
Date: Sat, 15 Aug 1998 23:33:41 +0200
Message-ID: <6r4uq5$if4$1_at_news.metronet.de>
Date: Sat, 15 Aug 1998 23:33:41 +0200
Message-ID: <6r4uq5$if4$1_at_news.metronet.de>
Dear Joep,
try this :
where rtrim(ltrim(replace(phone#, '01234567890-', ' '))) != '' i.e. all records with a phone# , that includes other characters , than 1,2,3,4,5,6,7,8,9,0,-.
Good luck,
Martin
Joep Hendrix schrieb in Nachricht <35D1E1ED.28C6_at_wxs.nl>...
>Hello,
>
>There is a table whith a column telephone. I want to select all the
>rows in this table telephone has other characters then numbers (0 to
>9), space or a dash(-).
>
>In plsql it is easy but I need a sql query to get these rows.
>
>Does anybody has any advice?
>
>Thanks,
>
>Joep
Received on Sat Aug 15 1998 - 23:33:41 CEST