Calculate Area - Most Advanced UOC

create function fn_calc_uoc_area(@FromConversionUnit varchar(64),@ToConversionUnit varchar(64),@UnitValue float)
returns float
as
begin

--AREA
/*
=========ACRONYM==========
sqcm   - square centimeter
sqft   - square feet
sqinch - square inch
sqkm   - square kilometer
sqmt   - square meters
sqmi   - square mile
sqmm   - square millimeter
sqyd   - square yard

*/
declare @returnvalue float

select @returnvalue = 
case 
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'hectares' then @UnitValue * 0.40468564224
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqcm' then @UnitValue * 40468564.224
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqft' then @UnitValue * 43560.0
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqinch' then @UnitValue * 6272640.0
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.0040468564224
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqmt' then @UnitValue * 4046.8564224
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.0015625
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqmm' then @UnitValue * 4046856422.4
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'sqyd' then @UnitValue * 4840.0
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'cent' then @UnitValue * 100.0
when @FromConversionUnit = 'acres' and @ToConversionUnit = 'ground' then @UnitValue * 18.15

when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'acres' then @UnitValue * 2.471053814671653
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqcm' then @UnitValue * 100000000.0
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqft' then @UnitValue * 107639.1041670972
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqinch' then @UnitValue * 15500031.000062
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.01
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqmt' then @UnitValue * 10000.0
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.0038610215854245
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqmm' then @UnitValue * 10000000000.0
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'sqyd' then @UnitValue * 11959.9004630108
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'cent' then @UnitValue * 247.105
when @FromConversionUnit = 'hectares' and @ToConversionUnit = 'ground' then @UnitValue * 44.8496

when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'acres' then @UnitValue * 0.000000024710538146717
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'hectares' then @UnitValue * 0.00000001
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqft' then @UnitValue * 0.001076391041671
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqinch' then @UnitValue * 0.15500031000062
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.0000000001
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqmt' then @UnitValue * 0.0001
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.000000000038610215854245
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqmm' then @UnitValue * 100.0
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'sqyd' then @UnitValue * 0.00011959900463011
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'cent' then @UnitValue * 0.000002471
when @FromConversionUnit = 'sqcm' and @ToConversionUnit = 'ground' then @UnitValue * 0.0000004485

when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'acres' then @UnitValue * 0.000022956841138659
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'hectares' then @UnitValue * 0.000009290304
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqcm' then @UnitValue * 929.0304
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqinch' then @UnitValue * 144.0
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.00000009290304
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqmt' then @UnitValue * 0.09290304
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.000000035870064279155
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqmm' then @UnitValue * 92903.04
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'sqyd' then @UnitValue * 0.1111111111111111
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'cent' then @UnitValue * 0.002296
when @FromConversionUnit = 'sqft' and @ToConversionUnit = 'ground' then @UnitValue * 0.0004167

when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'acres' then @UnitValue * 0.00000015942250790736
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'hectares' then @UnitValue * 0.000000064516
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqcm' then @UnitValue * 6.4516
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqft' then @UnitValue * 0.0069444444444444
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.00000000064516
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqmt' then @UnitValue * 0.00064516
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.00000000024909766860524
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqmm' then @UnitValue * 645.16
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'sqyd' then @UnitValue * 0.0007716049382716
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'cent' then @UnitValue * 0.00001594
when @FromConversionUnit = 'sqinch' and @ToConversionUnit = 'ground' then @UnitValue * 0.000002893

when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'acres' then @UnitValue * 247.1053814671653
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'hectares' then @UnitValue * 100.0
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqcm' then @UnitValue * 10000000000.0
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqft' then @UnitValue * 10763910.41670972
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqinch' then @UnitValue * 1550003100.0062
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqmt' then @UnitValue * 1000000.0
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.3861021585424458
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqmm' then @UnitValue * 1000000000000.0
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'sqyd' then @UnitValue * 1195990.04630108
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'cent' then @UnitValue * 24710.5407
when @FromConversionUnit = 'sqkm' and @ToConversionUnit = 'ground' then @UnitValue * 4484.965

when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'acres' then @UnitValue * 0.00024710538146717
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'hectares' then @UnitValue * 0.0001
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqcm' then @UnitValue * 10000.0
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqft' then @UnitValue * 10.76391041670972
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqinch' then @UnitValue * 1550.0031000062
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.000001
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.00000038610215854245
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqmm' then @UnitValue * 1000000.0
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'sqyd' then @UnitValue * 1.19599004630108
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'cent' then @UnitValue * 0.02471
when @FromConversionUnit = 'sqmt' and @ToConversionUnit = 'ground' then @UnitValue * 0.004485

when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'acres' then @UnitValue * 640.0
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'hectares' then @UnitValue * 258.9988110336
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqcm' then @UnitValue * 25899881103.36
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqft' then @UnitValue * 27878400.0
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqinch' then @UnitValue * 4014489600.0
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqkm' then @UnitValue * 2.589988110336
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqmt' then @UnitValue * 2589988.110336
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqmm' then @UnitValue * 2589988110336.0
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'sqyd' then @UnitValue * 3097600.0
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'cent' then @UnitValue * 64000.0067
when @FromConversionUnit = 'sqmi' and @ToConversionUnit = 'ground' then @UnitValue * 11616.005

when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'acres' then @UnitValue * 0.00000000024710538146717
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'hectares' then @UnitValue * 0.0000000001
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqcm' then @UnitValue * 0.01
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqft' then @UnitValue * 0.00001076391041671
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqinch' then @UnitValue * 0.0015500031000062
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.000000000001
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqmt' then @UnitValue * 0.000001
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.00000000000038610215854245
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'sqyd' then @UnitValue * 0.0000011959900463011
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'cent' then @UnitValue * 0.00000002471
when @FromConversionUnit = 'sqmm' and @ToConversionUnit = 'ground' then @UnitValue * 0.000000004485

when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'acres' then @UnitValue * 0.00020661157024793
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'hectares' then @UnitValue * 0.000083612736
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqcm' then @UnitValue * 8361.2736
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqft' then @UnitValue * 9.0
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqinch' then @UnitValue * 1296.0
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.00000083612736
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqmt' then @UnitValue * 0.83612736
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.0000003228305785124
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'sqmm' then @UnitValue * 836127.36
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'cent' then @UnitValue * 0.02066
when @FromConversionUnit = 'sqyd' and @ToConversionUnit = 'ground' then @UnitValue * 0.00375

when @FromConversionUnit = 'cent' and @ToConversionUnit = 'acres' then @UnitValue * 0.001
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'hectares' then @UnitValue * 0.004047
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqcm' then @UnitValue * 404685.6
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqft' then @UnitValue * 435.6
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqinch' then @UnitValue * 62741.9535
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.00004047
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqmt' then @UnitValue * 40.4686
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.00001562
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqmm' then @UnitValue * 40468560.0
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'sqyd' then @UnitValue * 48.4
when @FromConversionUnit = 'cent' and @ToConversionUnit = 'ground' then @UnitValue * 0.1815

when @FromConversionUnit = 'ground' and @ToConversionUnit = 'acres' then @UnitValue * 0.05509
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'hectares' then @UnitValue * 0.02229672
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqcm' then @UnitValue * 2229672
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqft' then @UnitValue * 2400.0
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqinch' then @UnitValue * 345685.5814
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqkm' then @UnitValue * 0.0002229672
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqmt' then @UnitValue * 222.9672
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqmi' then @UnitValue * 0.00008609
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqmm' then @UnitValue * 222967200
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'sqyd' then @UnitValue * 266.6666
when @FromConversionUnit = 'ground' and @ToConversionUnit = 'cent' then @UnitValue * 5.50964

when @FromConversionUnit = @ToConversionUnit then @UnitValue * 1.0
end

return(@returnvalue)

end
go


--examples
select dbo.fn_calc_uoc_area('acres','hectares',10)
select dbo.fn_calc_uoc_area('acres','sqcm',10)
select dbo.fn_calc_uoc_area('acres','sqft',10)
select dbo.fn_calc_uoc_area('acres','sqinch',10)
select dbo.fn_calc_uoc_area('acres','sqkm',10)
select dbo.fn_calc_uoc_area('acres','sqmt',10)
select dbo.fn_calc_uoc_area('acres','sqmi',10)
select dbo.fn_calc_uoc_area('acres','sqmm',10)
select dbo.fn_calc_uoc_area('acres','sqyd',10)
select dbo.fn_calc_uoc_area('acres','cent',10)
select dbo.fn_calc_uoc_area('acres','ground',10)

select dbo.fn_calc_uoc_area('hectares','acres',10)
select dbo.fn_calc_uoc_area('hectares','sqcm',10)
select dbo.fn_calc_uoc_area('hectares','sqft',10)
select dbo.fn_calc_uoc_area('hectares','sqinch',10)
select dbo.fn_calc_uoc_area('hectares','sqkm',10)
select dbo.fn_calc_uoc_area('hectares','sqmt',10)
select dbo.fn_calc_uoc_area('hectares','sqmi',10)
select dbo.fn_calc_uoc_area('hectares','sqmm',10)
select dbo.fn_calc_uoc_area('hectares','sqyd',10)
select dbo.fn_calc_uoc_area('hectares','cent',10)
select dbo.fn_calc_uoc_area('hectares','ground',10)

select dbo.fn_calc_uoc_area('sqcm','acres',10)
select dbo.fn_calc_uoc_area('sqcm','hectares',10)
select dbo.fn_calc_uoc_area('sqcm','sqft',10)
select dbo.fn_calc_uoc_area('sqcm','sqinch',10)
select dbo.fn_calc_uoc_area('sqcm','sqkm',10)
select dbo.fn_calc_uoc_area('sqcm','sqmt',10)
select dbo.fn_calc_uoc_area('sqcm','sqmi',10)
select dbo.fn_calc_uoc_area('sqcm','sqmm',10)
select dbo.fn_calc_uoc_area('sqcm','sqyd',10)
select dbo.fn_calc_uoc_area('sqcm','cent',10)
select dbo.fn_calc_uoc_area('sqcm','ground',10)

select dbo.fn_calc_uoc_area('sqft','acres',10)
select dbo.fn_calc_uoc_area('sqft','hectares',10)
select dbo.fn_calc_uoc_area('sqft','sqcm',10)
select dbo.fn_calc_uoc_area('sqft','sqinch',10)
select dbo.fn_calc_uoc_area('sqft','sqkm',10)
select dbo.fn_calc_uoc_area('sqft','sqmt',10)
select dbo.fn_calc_uoc_area('sqft','sqmi',10)
select dbo.fn_calc_uoc_area('sqft','sqmm',10)
select dbo.fn_calc_uoc_area('sqft','sqyd',10)
select dbo.fn_calc_uoc_area('sqft','cent',10)
select dbo.fn_calc_uoc_area('sqft','ground',10)

select dbo.fn_calc_uoc_area('sqinch','acres',10)
select dbo.fn_calc_uoc_area('sqinch','hectares',10)
select dbo.fn_calc_uoc_area('sqinch','sqcm',10)
select dbo.fn_calc_uoc_area('sqinch','sqft',10)
select dbo.fn_calc_uoc_area('sqinch','sqkm',10)
select dbo.fn_calc_uoc_area('sqinch','sqmt',10)
select dbo.fn_calc_uoc_area('sqinch','sqmi',10)
select dbo.fn_calc_uoc_area('sqinch','sqmm',10)
select dbo.fn_calc_uoc_area('sqinch','sqyd',10)
select dbo.fn_calc_uoc_area('sqinch','cent',10)
select dbo.fn_calc_uoc_area('sqinch','ground',10)

select dbo.fn_calc_uoc_area('sqkm','acres',10)
select dbo.fn_calc_uoc_area('sqkm','hectares',10)
select dbo.fn_calc_uoc_area('sqkm','sqcm',10)
select dbo.fn_calc_uoc_area('sqkm','sqft',10)
select dbo.fn_calc_uoc_area('sqkm','sqinch',10)
select dbo.fn_calc_uoc_area('sqkm','sqmt',10)
select dbo.fn_calc_uoc_area('sqkm','sqmi',10)
select dbo.fn_calc_uoc_area('sqkm','sqmm',10)
select dbo.fn_calc_uoc_area('sqkm','sqyd',10)
select dbo.fn_calc_uoc_area('sqkm','cent',10)
select dbo.fn_calc_uoc_area('sqkm','ground',10)

select dbo.fn_calc_uoc_area('sqmt','acres',10)
select dbo.fn_calc_uoc_area('sqmt','hectares',10)
select dbo.fn_calc_uoc_area('sqmt','sqcm',10)
select dbo.fn_calc_uoc_area('sqmt','sqft',10)
select dbo.fn_calc_uoc_area('sqmt','sqinch',10)
select dbo.fn_calc_uoc_area('sqmt','sqkm',10)
select dbo.fn_calc_uoc_area('sqmt','sqmi',10)
select dbo.fn_calc_uoc_area('sqmt','sqmm',10)
select dbo.fn_calc_uoc_area('sqmt','sqyd',10)
select dbo.fn_calc_uoc_area('sqmt','cent',10)
select dbo.fn_calc_uoc_area('sqmt','ground',10)

select dbo.fn_calc_uoc_area('sqmi','acres',10)
select dbo.fn_calc_uoc_area('sqmi','hectares',10)
select dbo.fn_calc_uoc_area('sqmi','sqcm',10)
select dbo.fn_calc_uoc_area('sqmi','sqft',10)
select dbo.fn_calc_uoc_area('sqmi','sqinch',10)
select dbo.fn_calc_uoc_area('sqmi','sqkm',10)
select dbo.fn_calc_uoc_area('sqmi','sqmt',10)
select dbo.fn_calc_uoc_area('sqmi','sqmm',10)
select dbo.fn_calc_uoc_area('sqmi','sqyd',10)
select dbo.fn_calc_uoc_area('sqmi','cent',10)
select dbo.fn_calc_uoc_area('sqmi','ground',10)

select dbo.fn_calc_uoc_area('sqmm','acres',10)
select dbo.fn_calc_uoc_area('sqmm','hectares',10)
select dbo.fn_calc_uoc_area('sqmm','sqcm',10)
select dbo.fn_calc_uoc_area('sqmm','sqft',10)
select dbo.fn_calc_uoc_area('sqmm','sqinch',10)
select dbo.fn_calc_uoc_area('sqmm','sqkm',10)
select dbo.fn_calc_uoc_area('sqmm','sqmt',10)
select dbo.fn_calc_uoc_area('sqmm','sqmi',10)
select dbo.fn_calc_uoc_area('sqmm','sqyd',10)
select dbo.fn_calc_uoc_area('sqmm','cent',10)
select dbo.fn_calc_uoc_area('sqmm','ground',10)

select dbo.fn_calc_uoc_area('sqyd','acres',10)
select dbo.fn_calc_uoc_area('sqyd','hectares',10)
select dbo.fn_calc_uoc_area('sqyd','sqcm',10)
select dbo.fn_calc_uoc_area('sqyd','sqft',10)
select dbo.fn_calc_uoc_area('sqyd','sqinch',10)
select dbo.fn_calc_uoc_area('sqyd','sqkm',10)
select dbo.fn_calc_uoc_area('sqyd','sqmt',10)
select dbo.fn_calc_uoc_area('sqyd','sqmi',10)
select dbo.fn_calc_uoc_area('sqyd','sqmm',10)
select dbo.fn_calc_uoc_area('sqyd','cent',10)
select dbo.fn_calc_uoc_area('sqyd','ground',10)

select dbo.fn_calc_uoc_area('cent','acres',10)
select dbo.fn_calc_uoc_area('cent','hectares',10)
select dbo.fn_calc_uoc_area('cent','sqcm',10)
select dbo.fn_calc_uoc_area('cent','sqft',10)
select dbo.fn_calc_uoc_area('cent','sqinch',10)
select dbo.fn_calc_uoc_area('cent','sqkm',10)
select dbo.fn_calc_uoc_area('cent','sqmt',10)
select dbo.fn_calc_uoc_area('cent','sqmi',10)
select dbo.fn_calc_uoc_area('cent','sqmm',10)
select dbo.fn_calc_uoc_area('cent','sqyd',10)
select dbo.fn_calc_uoc_area('cent','ground',10)

select dbo.fn_calc_uoc_area('ground','acres',10)
select dbo.fn_calc_uoc_area('ground','hectares',10)
select dbo.fn_calc_uoc_area('ground','sqcm',10)
select dbo.fn_calc_uoc_area('ground','sqft',10)
select dbo.fn_calc_uoc_area('ground','sqinch',10)
select dbo.fn_calc_uoc_area('ground','sqkm',10)
select dbo.fn_calc_uoc_area('ground','sqmt',10)
select dbo.fn_calc_uoc_area('ground','sqmi',10)
select dbo.fn_calc_uoc_area('ground','sqmm',10)
select dbo.fn_calc_uoc_area('ground','sqyd',10)
select dbo.fn_calc_uoc_area('ground','cent',10)