<font face="Arial">Hi<br /><br /> I need to clean up phone-numbers. Somehow I got a Excel list that has weird graphical
characterstrailing some of the entries.</font><br /><font face="Arial"><font face="Arial">My DB is UTF8 so it would
storethis mess but I don<small>'t like to import it in the first place.<br /><br /> OK, I know how to read the stuff
intoa temporary table to clean it up before the actual import.<br /></small></font>How can I do an update on the column
thatdeletes every char that is not in a given set of chars like '+- 0123456/()'?<br /><br /><small></small><br />
Secondbut similar question:<br /> How can I select records that have fields that contain characters not included in a
givenalphabet?<br /> E.G. find fields that contain some char not in 0-9,a-z,A-Z, +-()/?<br /><br /><br /> regards<br />
Andreas<br/></font>
