create
function
replace_@
(@EMAIL
VARCHAR
(50))
RETURNS
@
temp
Table
(str_eamil
varchar
as
begin
declare
@str
(50)
set
@str=
replace
(@EMAIL,
'++'
,
'#'
)
insert
values
(@str)
return
end
go