FUNCTION fNormalizeString

Returns string upshifted, squeezed blanks, trailing zeros removed, and blank added on end

select dbo.fNormalizeString('Region Convex 3.0000 5 7')
returns 'REGION CONVEX 3.0 5 7 '

Input and output parameters

name type length inout pnum

varchar 8000 input 0

@s varchar 8000 input 1