an easy way is:

Starting enterprise manager go to the  "data transformation services". Go to the dts-pakage you want to transfer. open it in design mode. in the window with the dts-package you go...

you can test this function. the inputparameters are @value - field you want to get result

@trenn - in front of this character you want to trim spaces

create  function dbo.test (@value...

case when extendedprice <> 0 then CONVERT(varchar,CAST(round([GrossMargin]/[ExtendedPrice]*100, 2) AS float)) else '0.00' end + '%' as percentage

udo