temporary user define function

[Eddie_A]

Temporary user define function:

create proc Procecess_NCR_Conversion
as

create function #Number_Format (@NCR_Conversion univarchar(500) )
returns univarchar(500)
as
begin
-- codes that converts NCR to unicode
. . .
end

update mytable
set first_nm = #NCR_Conversion(first_nm)
where first_nm like '%&#[0-9]%;'
go

[Eddie_A]

This will be very useful as a sub routine as opposed to creating
nested SP. What do you think?

Correction for above example:

create proc Convert_NCR_to_Unicode
as

create function #NCR_Conversion (@NCR_strings univarchar(500) )
returns univarchar(500)
as
begin -- or use (

-- codes that converts NCR to unicode
. . .

return @NCR_strings
end -- or use )