Simple SQL or PHP Query
oDesk - New York, NY

This job posting is no longer available on oDesk. Find similar jobs:oDesk jobs

I have a table that has two fields, one with Acronym and one with Name that I want to extract the Core Acronym and Core Name by removing the common words.

e.g. record from

Table X

Senior CAD Artist | Senior Computer Aided Design Artist

creates new record in

Table Z

CAD | Computer Aided Design

by removing the common words (Senior, Artist)

from each side

I want to be able to specify something along the lines of

Call AcronymFunction (SourceTableName, SourceTableAcronymField, SourceTableNameField, DestinationTableName, DestinationTableAcronymField, DestinationNameFIeld)

Please quote both your hourly rate and estimate time to complete. More tasks avaialable./