db2 udf string function

Completed Posted Jun 22, 2010 Paid on delivery
Completed Paid on delivery

If any of the characters in the name field are not between A & Z

then replace all non-alpha characters with spaces:

or if the name field contrains street then return spaces.

input output

SULIMAN` SULIMAN

HERMAN & GERTRUDE GROD HERMAN GERTRUDE GROD

MARIE) MARIE

GIUSEPPE/ANTONIA GIUSEPPE ANTONIA

NURY (ALICIA) NURY ALICIA

3

0

#301

GERALINE (JURILENE) GERALINE JURILENE

#7

CATHERINE* CATHERINE

L0CKHART LCKHART

859 "B" STREET

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

the coder must be exellent in db2 udb2 udf on unix

and DB2 Developer Workbench

Database Administration MySQL SQL

Project ID: #3521071

About the project

3 proposals Remote project Active Jun 29, 2010

Awarded to:

BitHoven

See private message.

$21.25 USD in 4 days
(17 Reviews)
4.3

3 freelancers are bidding on average $17 for this job

jkddeveloper

See private message.

$17 USD in 4 days
(2 Reviews)
1.0
hazemelraffiee

See private message.

$12.75 USD in 4 days
(3 Reviews)
0.8