Deleting unwanted characters in a field 1

See the UDF keyword ;-)).
Download and install the 'free UDF library' or 'rFunc UDF library'. You can find in both package enhanced string functions like replace.

Thanks otto! I had run a perl script at interbase to get my results since I had a time frame involved.
I tried the UDF's on some other test data and suprisngly they work pretty good on data manipulation. Great advice, Thanks! I didn't know that existed...

FYI for the PERL:

use DBI;
use dbd:dbc;

$dbh = DBI->connect("dbi:ODBC:sourcedb", "username", "password"
#phones
#select (id,phone) from guest
$sth = $dbh->prepare("select id,phone from guest"
$sth->execute();


while (@row = $sth->fetchrow_array)
{
if ($row[1] =~ /-/ or $row[1] =~ /\(/ or $row[1] =~ /\)/)
{
print "@row\n";
$del = $row[1];
$del =~ s/-//g;
$del =~ s/\(//g;
$del =~ s/\)//g;
print "$del\n";
$update = $dbh->prepare("update guest set phone = \"$del\" where id = $row[0]"
$update->execute;
}
}

#update guest
#set phone = $del where id = $row[0]