Do you know of any solution that does not require the use of an external
function? (an SQL language UDF?, combo of SQL UDF and stored proc?,etc.)

To summarize the issue again ...
When a row is inserted into a table containing a column value 'Jo_es' , I
want to change it to 'Jones' based on a simple query against a tblNames
table using sql similar to
select name from tblNames where name like 'Jo_es'
It's just that 'Jo_es' is not hard coded but comes from the result of a
query ..


Thanks,
Bill
"Serge Rielau" <srielau@ca.ibm.com> wrote in message
news:2sgsu2F1jkm8pU1@uni-berlin.de...
> Bill Smith wrote:
>
>> Yes, This functionality is a major issue for me. I need to find some way
>> to update the column value from the pattern to a result that matches the
>> pattern. Are you saying I can get the functionality I want by calling an
>> external function that resides in the MTK?
>> Bill
> Correct. Just download the MTK and go shopping.
>
> There are a bunch of interesting Sybase/SQL Server and Oracle functions
> you can snicker.
>
> Cheers
> Serge