Calculate Length - Most Advanced UOC

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

--LENGTH


declare @returnvalue float

select @returnvalue = 
case 
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'centimeters' then @UnitValue * 0.00000001
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'chain' then @UnitValue * 4.970969537898672e-12
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'fathom' then @UnitValue * 5.468066491688539e-11
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'feet' then @UnitValue * 3.280839895013123e-10
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'hand' then @UnitValue * 9.84251968503937e-10
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'inch' then @UnitValue * 3.937007874015748e-9
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0000000000001
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'link' then @UnitValue * 4.970969537898672e-10
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'meter' then @UnitValue * 0.0000000001
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'microns' then @UnitValue * 0.0001
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'mile' then @UnitValue * 6.21371192237334e-14
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'millimeters' then @UnitValue * 0.0000001
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'nanometer' then @UnitValue * 0.1
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.399568034557235e-14
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'pica' then @UnitValue * 2.371063015836614e-8
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'rods' then @UnitValue * 1.988387815159469e-11
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'span' then @UnitValue * 4.374453193350831e-10
when @FromConversionUnit = 'angstrom' and @ToConversionUnit = 'yard' then @UnitValue * 1.093613298337708e-10

when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'angstrom' then @UnitValue * 100000000.0
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'chain' then @UnitValue * 4.970969537898672e-4
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'fathom' then @UnitValue * 0.0054680664916885
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'feet' then @UnitValue * 0.0328083989501312
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'hand' then @UnitValue * 0.0984251968503937
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'inch' then @UnitValue * 0.3937007874015748
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.00001
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'link' then @UnitValue * 0.0497096953789867
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'meter' then @UnitValue * 0.01
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'microns' then @UnitValue * 10000.0
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'mile' then @UnitValue * 6.21371192237334e-6
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'millimeters' then @UnitValue * 10.0
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'nanometer' then @UnitValue * 10000000.0
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.399568034557235e-6
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'pica' then @UnitValue * 2.371063015836614
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'rods' then @UnitValue * 0.0019883878151595
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'span' then @UnitValue * 0.0437445319335083
when @FromConversionUnit = 'centimeters' and @ToConversionUnit = 'yard' then @UnitValue * 0.0109361329833771

when @FromConversionUnit = 'chain' and @ToConversionUnit = 'angstrom' then @UnitValue * 201168000000.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'centimeters' then @UnitValue * 2011.68
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'fathom' then @UnitValue * 11.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'feet' then @UnitValue * 66.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'hand' then @UnitValue * 198.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'inch' then @UnitValue * 792.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0201168
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'link' then @UnitValue * 100.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'meter' then @UnitValue * 20.1168
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'microns' then @UnitValue * 20116800.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'mile' then @UnitValue * 0.0125
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'millimeters' then @UnitValue * 20116.8
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'nanometer' then @UnitValue * 20116800000.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'nautical miles' then @UnitValue * 0.0108622030237581
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'pica' then @UnitValue * 4769.8200476982
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'rods' then @UnitValue * 4.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'span' then @UnitValue * 88.0
when @FromConversionUnit = 'chain' and @ToConversionUnit = 'yard' then @UnitValue * 22.0

when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'angstrom' then @UnitValue * 18288000000.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'centimeters' then @UnitValue * 182.88
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'chain' then @UnitValue * 0.0909090909090909
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'feet' then @UnitValue * 6.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'hand' then @UnitValue * 18.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'inch' then @UnitValue * 72.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0018288
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'link' then @UnitValue * 9.090909090909091
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'meter' then @UnitValue * 1.8288
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'microns' then @UnitValue * 1828800.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'mile' then @UnitValue * 0.0011363636363636
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'millimeters' then @UnitValue * 1828.8
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'nanometer' then @UnitValue * 1828800000.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'nautical miles' then @UnitValue * 9.874730021598272e-4
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'pica' then @UnitValue * 433.6200043362
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'rods' then @UnitValue * 0.3636363636363636
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'span' then @UnitValue * 8.0
when @FromConversionUnit = 'fathom' and @ToConversionUnit = 'yard' then @UnitValue * 2.0

when @FromConversionUnit = 'feet' and @ToConversionUnit = 'angstrom' then @UnitValue * 3048000000.0
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'centimeters' then @UnitValue * 30.48
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'chain' then @UnitValue * 0.0151515151515152
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'fathom' then @UnitValue * 0.1666666666666667
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'hand' then @UnitValue * 3.0
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'inch' then @UnitValue * 12.0
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0003048
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'link' then @UnitValue * 1.515151515151515
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'meter' then @UnitValue * 0.3048
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'microns' then @UnitValue * 304800.0
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'mile' then @UnitValue * 1.893939393939394e-4
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'millimeters' then @UnitValue * 304.8
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'nanometer' then @UnitValue * 304800000.0
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'nautical miles' then @UnitValue * 1.645788336933045e-4
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'pica' then @UnitValue * 72.27000072270001
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'rods' then @UnitValue * 0.0606060606060606
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'span' then @UnitValue * 1.333333333333333
when @FromConversionUnit = 'feet' and @ToConversionUnit = 'yard' then @UnitValue * 0.3333333333333333

when @FromConversionUnit = 'hand' and @ToConversionUnit = 'angstrom' then @UnitValue * 1016000000.0
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'centimeters' then @UnitValue * 10.16
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'chain' then @UnitValue * 0.0050505050505051
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'fathom' then @UnitValue * 0.0555555555555556
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'feet' then @UnitValue * 0.3333333333333333
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'inch' then @UnitValue * 4.0
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0001016
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'link' then @UnitValue * 0.5050505050505051
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'meter' then @UnitValue * 0.1016
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'microns' then @UnitValue * 101600.0
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'mile' then @UnitValue * 6.313131313131313e-5
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'millimeters' then @UnitValue * 101.6
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'nanometer' then @UnitValue * 101600000.0
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.485961123110151e-5
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'pica' then @UnitValue * 24.0900002409
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'rods' then @UnitValue * 0.0606060606060606
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'span' then @UnitValue * 0.0202020202020202
when @FromConversionUnit = 'hand' and @ToConversionUnit = 'yard' then @UnitValue * 0.1111111111111111

when @FromConversionUnit = 'inch' and @ToConversionUnit = 'angstrom' then @UnitValue * 254000000.0
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'centimeters' then @UnitValue * 2.54
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'chain' then @UnitValue * 0.0012626262626263
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'fathom' then @UnitValue * 0.0138888888888889
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'feet' then @UnitValue * 0.0833333333333333
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'hand' then @UnitValue * 0.25
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0000254
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'link' then @UnitValue * 0.1262626262626263
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'meter' then @UnitValue * 0.0254
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'microns' then @UnitValue * 25400.0
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'mile' then @UnitValue * 1.578282828282828e-5
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'millimeters' then @UnitValue * 25.4
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'nanometer' then @UnitValue * 25400000.0
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'nautical miles' then @UnitValue * 1.371490280777538e-5
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'pica' then @UnitValue * 6.022500060225001
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'rods' then @UnitValue * 0.0050505050505051
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'span' then @UnitValue * 0.1111111111111111
when @FromConversionUnit = 'inch' and @ToConversionUnit = 'yard' then @UnitValue * 0.0277777777777778

when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'angstrom' then @UnitValue * 10000000000000.0
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'centimeters' then @UnitValue * 100000.0
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'chain' then @UnitValue * 49.70969537898672
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'fathom' then @UnitValue * 546.8066491688539
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'feet' then @UnitValue * 3280.839895013123
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'hand' then @UnitValue * 9842.51968503937
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'inch' then @UnitValue * 39370.07874015748
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'link' then @UnitValue * 4970.969537898672
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'meter' then @UnitValue * 1000.0
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'microns' then @UnitValue * 1000000000.0
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'mile' then @UnitValue * 0.621371192237334
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'millimeters' then @UnitValue * 1000000.0
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'nanometer' then @UnitValue * 1000000000000.0
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'nautical miles' then @UnitValue * 0.5399568034557235
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'pica' then @UnitValue * 237106.3015836614
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'rods' then @UnitValue * 198.8387815159469
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'span' then @UnitValue * 4374.453193350831
when @FromConversionUnit = 'kilometers' and @ToConversionUnit = 'yard' then @UnitValue * 1093.613298337708

when @FromConversionUnit = 'link' and @ToConversionUnit = 'angstrom' then @UnitValue * 2011680000.0
when @FromConversionUnit = 'link' and @ToConversionUnit = 'centimeters' then @UnitValue * 20.1168
when @FromConversionUnit = 'link' and @ToConversionUnit = 'chain' then @UnitValue * 0.01
when @FromConversionUnit = 'link' and @ToConversionUnit = 'fathom' then @UnitValue * 0.11
when @FromConversionUnit = 'link' and @ToConversionUnit = 'feet' then @UnitValue * 0.66
when @FromConversionUnit = 'link' and @ToConversionUnit = 'hand' then @UnitValue * 1.98
when @FromConversionUnit = 'link' and @ToConversionUnit = 'inch' then @UnitValue * 7.92
when @FromConversionUnit = 'link' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.000201168
when @FromConversionUnit = 'link' and @ToConversionUnit = 'meter' then @UnitValue * 0.201168
when @FromConversionUnit = 'link' and @ToConversionUnit = 'microns' then @UnitValue * 201168.0
when @FromConversionUnit = 'link' and @ToConversionUnit = 'mile' then @UnitValue * 0.000125
when @FromConversionUnit = 'link' and @ToConversionUnit = 'millimeters' then @UnitValue * 201.168
when @FromConversionUnit = 'link' and @ToConversionUnit = 'nanometer' then @UnitValue * 201168000.0
when @FromConversionUnit = 'link' and @ToConversionUnit = 'nautical miles' then @UnitValue * 1.08622030237581e-4
when @FromConversionUnit = 'link' and @ToConversionUnit = 'pica' then @UnitValue * 47.698200476982
when @FromConversionUnit = 'link' and @ToConversionUnit = 'rods' then @UnitValue * 0.04
when @FromConversionUnit = 'link' and @ToConversionUnit = 'span' then @UnitValue * 0.88
when @FromConversionUnit = 'link' and @ToConversionUnit = 'yard' then @UnitValue * 0.22

when @FromConversionUnit = 'meter' and @ToConversionUnit = 'angstrom' then @UnitValue * 10000000000.0
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'centimeters' then @UnitValue * 100.0
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'chain' then @UnitValue * 0.0497096953789867
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'fathom' then @UnitValue * 0.5468066491688539
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'feet' then @UnitValue * 3.280839895013123
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'hand' then @UnitValue * 9.84251968503937
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'inch' then @UnitValue * 39.37007874015748
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.001
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'link' then @UnitValue * 4.970969537898672
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'microns' then @UnitValue * 1000000.0
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'mile' then @UnitValue * 6.21371192237334e-4
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'millimeters' then @UnitValue * 1000.0
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'nanometer' then @UnitValue * 1000000000.0
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.399568034557235e-4
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'pica' then @UnitValue * 237.1063015836614
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'rods' then @UnitValue * 0.1988387815159469
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'span' then @UnitValue * 4.374453193350831
when @FromConversionUnit = 'meter' and @ToConversionUnit = 'yard' then @UnitValue * 1.093613298337708

when @FromConversionUnit = 'microns' and @ToConversionUnit = 'angstrom' then @UnitValue * 10000.0
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'centimeters' then @UnitValue * 0.0001
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'chain' then @UnitValue * 4.970969537898672e-8
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'fathom' then @UnitValue * 5.468066491688539e-7
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'feet' then @UnitValue * 3.280839895013123e-6
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'hand' then @UnitValue * 9.84251968503937e-6
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'inch' then @UnitValue * 3.937007874015748e-5
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.000000001
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'link' then @UnitValue * 4.970969537898672e-6
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'meter' then @UnitValue * 0.000001
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'mile' then @UnitValue * 6.21371192237334e-10
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'millimeters' then @UnitValue * 0.001
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'nanometer' then @UnitValue * 1000.0
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.399568034557235e-10
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'pica' then @UnitValue * 2.371063015836614e-4
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'rods' then @UnitValue * 1.988387815159469e-7
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'span' then @UnitValue * 4.374453193350831e-6
when @FromConversionUnit = 'microns' and @ToConversionUnit = 'yard' then @UnitValue * 1.093613298337708e-6

when @FromConversionUnit = 'mile' and @ToConversionUnit = 'angstrom' then @UnitValue * 16093440000000.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'centimeters' then @UnitValue * 160934.4
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'chain' then @UnitValue * 80.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'fathom' then @UnitValue * 880.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'feet' then @UnitValue * 5280.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'hand' then @UnitValue * 15840.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'inch' then @UnitValue * 63360.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'kilometers' then @UnitValue * 1.609344
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'link' then @UnitValue * 8000.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'meter' then @UnitValue * 1609.344
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'microns' then @UnitValue * 1609344000.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'millimeters' then @UnitValue * 1609344.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'nanometer' then @UnitValue * 1609344000000.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'nautical miles' then @UnitValue * 0.8689762419006479
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'pica' then @UnitValue * 381585.603815856
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'rods' then @UnitValue * 320.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'span' then @UnitValue * 7040.0
when @FromConversionUnit = 'mile' and @ToConversionUnit = 'yard' then @UnitValue * 1760.0

when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'angstrom' then @UnitValue * 10000000.0
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'centimeters' then @UnitValue * 0.1
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'chain' then @UnitValue * 4.970969537898672e-5
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'fathom' then @UnitValue * 5.468066491688539e-4
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'feet' then @UnitValue * 0.0032808398950131
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'hand' then @UnitValue * 0.0098425196850394
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'inch' then @UnitValue * 0.0393700787401575
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.000001
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'link' then @UnitValue * 0.0049709695378987
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'meter' then @UnitValue * 0.001
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'microns' then @UnitValue * 1000.0
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'mile' then @UnitValue * 6.21371192237334e-7
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'nanometer' then @UnitValue * 1000000.0
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.399568034557235e-7
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'pica' then @UnitValue * 0.2371063015836614
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'rods' then @UnitValue * 1.988387815159469e-4
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'span' then @UnitValue * 0.0043744531933508
when @FromConversionUnit = 'millimeters' and @ToConversionUnit = 'yard' then @UnitValue * 0.0010936132983377

when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'angstrom' then @UnitValue * 10.0
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'centimeters' then @UnitValue * 0.0000001
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'chain' then @UnitValue * 4.970969537898672e-11
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'fathom' then @UnitValue * 5.468066491688539e-10
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'feet' then @UnitValue * 3.280839895013123e-9
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'hand' then @UnitValue * 9.84251968503937e-9
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'inch' then @UnitValue * 3.937007874015748e-8
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.000000000001
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'link' then @UnitValue * 4.970969537898672e-9
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'meter' then @UnitValue * 0.000000001
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'microns' then @UnitValue * 0.001
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'mile' then @UnitValue * 6.21371192237334e-13
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'millimeters' then @UnitValue * 0.000001
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'nautical miles' then @UnitValue * 5.399568034557235e-13
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'pica' then @UnitValue * 2.371063015836614e-7
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'rods' then @UnitValue * 1.988387815159469e-10
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'span' then @UnitValue * 4.374453193350831e-9
when @FromConversionUnit = 'nanometer' and @ToConversionUnit = 'yard' then @UnitValue * 1.093613298337708e-9

when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'angstrom' then @UnitValue * 18520000000000.0
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'centimeters' then @UnitValue * 185200.0
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'chain' then @UnitValue * 92.0623558418834
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'fathom' then @UnitValue * 1012.685914260717
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'feet' then @UnitValue * 6076.115485564304
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'hand' then @UnitValue * 18228.34645669291
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'inch' then @UnitValue * 72913.38582677165
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'kilometers' then @UnitValue * 1.852
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'link' then @UnitValue * 9206.23558418834
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'meter' then @UnitValue * 1852.0
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'microns' then @UnitValue * 1852000000.0
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'mile' then @UnitValue * 1.150779448023543
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'millimeters' then @UnitValue * 1852000.0
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'nanometer' then @UnitValue * 1852000000000.0
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'pica' then @UnitValue * 439120.870532941
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'rods' then @UnitValue * 368.2494233675336
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'span' then @UnitValue * 8101.487314085739
when @FromConversionUnit = 'nautical miles' and @ToConversionUnit = 'yard' then @UnitValue * 2025.371828521435

when @FromConversionUnit = 'pica' and @ToConversionUnit = 'angstrom' then @UnitValue * 42175176.0
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'centimeters' then @UnitValue * 0.42175176
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'chain' then @UnitValue * 2.096515151515152e-4
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'fathom' then @UnitValue * 0.0023061666666667
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'feet' then @UnitValue * 0.013837
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'hand' then @UnitValue * 0.041511
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'inch' then @UnitValue * 0.166044
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0000042175176
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'link' then @UnitValue * 0.0209651515151515
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'meter' then @UnitValue * 0.0042175176
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'microns' then @UnitValue * 4217.5176
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'mile' then @UnitValue * 2.620643939393939e-6
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'millimeters' then @UnitValue * 4.2175176
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'nanometer' then @UnitValue * 4217517.6
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'nautical miles' then @UnitValue * 2.277277321814255e-6
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'rods' then @UnitValue * 8.386060606060606e-4
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'span' then @UnitValue * 0.0184493333333333
when @FromConversionUnit = 'pica' and @ToConversionUnit = 'yard' then @UnitValue * 0.0046123333333333

when @FromConversionUnit = 'rods' and @ToConversionUnit = 'angstrom' then @UnitValue * 50292000000.0
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'centimeters' then @UnitValue * 502.92
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'chain' then @UnitValue * 0.25
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'fathom' then @UnitValue * 2.75
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'feet' then @UnitValue * 16.5
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'hand' then @UnitValue * 49.5
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'inch' then @UnitValue * 198.0
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0050292
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'link' then @UnitValue * 25.0
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'meter' then @UnitValue * 5.0292
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'microns' then @UnitValue * 5029200.0
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'mile' then @UnitValue * 0.003125
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'millimeters' then @UnitValue * 5029.2
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'nanometer' then @UnitValue * 5029200000.0
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'nautical miles' then @UnitValue * 0.0027155507559395
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'pica' then @UnitValue * 1192.45501192455
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'span' then @UnitValue * 22.0
when @FromConversionUnit = 'rods' and @ToConversionUnit = 'yard' then @UnitValue * 5.5

when @FromConversionUnit = 'span' and @ToConversionUnit = 'angstrom' then @UnitValue * 2286000000.0
when @FromConversionUnit = 'span' and @ToConversionUnit = 'centimeters' then @UnitValue * 22.86
when @FromConversionUnit = 'span' and @ToConversionUnit = 'chain' then @UnitValue * 0.0113636363636364
when @FromConversionUnit = 'span' and @ToConversionUnit = 'fathom' then @UnitValue * 0.125
when @FromConversionUnit = 'span' and @ToConversionUnit = 'feet' then @UnitValue * 0.75
when @FromConversionUnit = 'span' and @ToConversionUnit = 'hand' then @UnitValue * 2.25
when @FromConversionUnit = 'span' and @ToConversionUnit = 'inch' then @UnitValue * 9.0
when @FromConversionUnit = 'span' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0002286
when @FromConversionUnit = 'span' and @ToConversionUnit = 'link' then @UnitValue * 1.136363636363636
when @FromConversionUnit = 'span' and @ToConversionUnit = 'meter' then @UnitValue * 0.2286
when @FromConversionUnit = 'span' and @ToConversionUnit = 'microns' then @UnitValue * 228600.0
when @FromConversionUnit = 'span' and @ToConversionUnit = 'mile' then @UnitValue * 1.420454545454545e-4
when @FromConversionUnit = 'span' and @ToConversionUnit = 'millimeters' then @UnitValue * 228.6
when @FromConversionUnit = 'span' and @ToConversionUnit = 'nanometer' then @UnitValue * 228600000.0
when @FromConversionUnit = 'span' and @ToConversionUnit = 'nautical miles' then @UnitValue * 1.234341252699784e-4
when @FromConversionUnit = 'span' and @ToConversionUnit = 'pica' then @UnitValue * 54.20250054202501
when @FromConversionUnit = 'span' and @ToConversionUnit = 'rods' then @UnitValue * 0.0454545454545455
when @FromConversionUnit = 'span' and @ToConversionUnit = 'yard' then @UnitValue * 0.25

when @FromConversionUnit = 'yard' and @ToConversionUnit = 'angstrom' then @UnitValue * 9144000000.0
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'centimeters' then @UnitValue * 91.44
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'chain' then @UnitValue * 0.0454545454545455
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'fathom' then @UnitValue * 0.5
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'feet' then @UnitValue * 3.0
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'hand' then @UnitValue * 9.0
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'inch' then @UnitValue * 36.0
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'kilometers' then @UnitValue * 0.0009144
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'link' then @UnitValue * 4.545454545454545
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'meter' then @UnitValue * 0.9144
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'microns' then @UnitValue * 914400.0
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'mile' then @UnitValue * 5.681818181818182e-4
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'millimeters' then @UnitValue * 914.4
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'nanometer' then @UnitValue * 914400000.0
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'nautical miles' then @UnitValue * 4.937365010799136e-4
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'pica' then @UnitValue * 216.8100021681
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'rods' then @UnitValue * 0.1818181818181818
when @FromConversionUnit = 'yard' and @ToConversionUnit = 'span' then @UnitValue * 4.0

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

return(@returnvalue)

end
go



--examples
select dbo.fn_calc_uoc_length('angstrom','centimeters' ,10)
select dbo.fn_calc_uoc_length('angstrom','chain',10)
select dbo.fn_calc_uoc_length('angstrom','fathom',10)
select dbo.fn_calc_uoc_length('angstrom','feet',10)
select dbo.fn_calc_uoc_length('angstrom','hand',10)
select dbo.fn_calc_uoc_length('angstrom','inch',10)
select dbo.fn_calc_uoc_length('angstrom','kilometers' ,10)
select dbo.fn_calc_uoc_length('angstrom','link',10)
select dbo.fn_calc_uoc_length('angstrom','meter',10)
select dbo.fn_calc_uoc_length('angstrom','microns',10)
select dbo.fn_calc_uoc_length('angstrom','mile',10)
select dbo.fn_calc_uoc_length('angstrom','millimeters',10)
select dbo.fn_calc_uoc_length('angstrom','nanometer' ,10)
select dbo.fn_calc_uoc_length('angstrom','nautical miles',10)
select dbo.fn_calc_uoc_length('angstrom','pica',10)
select dbo.fn_calc_uoc_length('angstrom','rods',10)
select dbo.fn_calc_uoc_length('angstrom','span',10)
select dbo.fn_calc_uoc_length('angstrom','yard',10)

select dbo.fn_calc_uoc_length('centimeters','angstrom' ,10)
select dbo.fn_calc_uoc_length('centimeters','chain',10)
select dbo.fn_calc_uoc_length('centimeters','fathom',10)
select dbo.fn_calc_uoc_length('centimeters','feet',10)
select dbo.fn_calc_uoc_length('centimeters','hand',10)
select dbo.fn_calc_uoc_length('centimeters','inch',10)
select dbo.fn_calc_uoc_length('centimeters','kilometers' ,10)
select dbo.fn_calc_uoc_length('centimeters','link',10)
select dbo.fn_calc_uoc_length('centimeters','meter',10)
select dbo.fn_calc_uoc_length('centimeters','microns',10)
select dbo.fn_calc_uoc_length('centimeters','mile',10)
select dbo.fn_calc_uoc_length('centimeters','millimeters',10)
select dbo.fn_calc_uoc_length('centimeters','nanometer' ,10)
select dbo.fn_calc_uoc_length('centimeters','nautical miles',10)
select dbo.fn_calc_uoc_length('centimeters','pica',10)
select dbo.fn_calc_uoc_length('centimeters','rods',10)
select dbo.fn_calc_uoc_length('centimeters','span',10)
select dbo.fn_calc_uoc_length('centimeters','yard',10)

select dbo.fn_calc_uoc_length('chain','angstrom' ,10)
select dbo.fn_calc_uoc_length('chain','centimeters',10)
select dbo.fn_calc_uoc_length('chain','fathom',10)
select dbo.fn_calc_uoc_length('chain','feet',10)
select dbo.fn_calc_uoc_length('chain','hand',10)
select dbo.fn_calc_uoc_length('chain','inch',10)
select dbo.fn_calc_uoc_length('chain','kilometers' ,10)
select dbo.fn_calc_uoc_length('chain','link',10)
select dbo.fn_calc_uoc_length('chain','meter',10)
select dbo.fn_calc_uoc_length('chain','microns',10)
select dbo.fn_calc_uoc_length('chain','mile',10)
select dbo.fn_calc_uoc_length('chain','millimeters',10)
select dbo.fn_calc_uoc_length('chain','nanometer' ,10)
select dbo.fn_calc_uoc_length('chain','nautical miles',10)
select dbo.fn_calc_uoc_length('chain','pica',10)
select dbo.fn_calc_uoc_length('chain','rods',10)
select dbo.fn_calc_uoc_length('chain','span',10)
select dbo.fn_calc_uoc_length('chain','yard',10)

select dbo.fn_calc_uoc_length('fathom','angstrom' ,10)
select dbo.fn_calc_uoc_length('fathom','centimeters',10)
select dbo.fn_calc_uoc_length('fathom','chain',10)
select dbo.fn_calc_uoc_length('fathom','feet',10)
select dbo.fn_calc_uoc_length('fathom','hand',10)
select dbo.fn_calc_uoc_length('fathom','inch',10)
select dbo.fn_calc_uoc_length('fathom','kilometers' ,10)
select dbo.fn_calc_uoc_length('fathom','link',10)
select dbo.fn_calc_uoc_length('fathom','meter',10)
select dbo.fn_calc_uoc_length('fathom','microns',10)
select dbo.fn_calc_uoc_length('fathom','mile',10)
select dbo.fn_calc_uoc_length('fathom','millimeters',10)
select dbo.fn_calc_uoc_length('fathom','nanometer' ,10)
select dbo.fn_calc_uoc_length('fathom','nautical miles',10)
select dbo.fn_calc_uoc_length('fathom','pica',10)
select dbo.fn_calc_uoc_length('fathom','rods',10)
select dbo.fn_calc_uoc_length('fathom','span',10)
select dbo.fn_calc_uoc_length('fathom','yard',10)

select dbo.fn_calc_uoc_length('feet','angstrom' ,10)
select dbo.fn_calc_uoc_length('feet','centimeters',10)
select dbo.fn_calc_uoc_length('feet','chain',10)
select dbo.fn_calc_uoc_length('feet','fathom',10)
select dbo.fn_calc_uoc_length('feet','hand',10)
select dbo.fn_calc_uoc_length('feet','inch',10)
select dbo.fn_calc_uoc_length('feet','kilometers' ,10)
select dbo.fn_calc_uoc_length('feet','link',10)
select dbo.fn_calc_uoc_length('feet','meter',10)
select dbo.fn_calc_uoc_length('feet','microns',10)
select dbo.fn_calc_uoc_length('feet','mile',10)
select dbo.fn_calc_uoc_length('feet','millimeters',10)
select dbo.fn_calc_uoc_length('feet','nanometer' ,10)
select dbo.fn_calc_uoc_length('feet','nautical miles',10)
select dbo.fn_calc_uoc_length('feet','pica',10)
select dbo.fn_calc_uoc_length('feet','rods',10)
select dbo.fn_calc_uoc_length('feet','span',10)
select dbo.fn_calc_uoc_length('feet','yard',10)

select dbo.fn_calc_uoc_length('hand','angstrom' ,10)
select dbo.fn_calc_uoc_length('hand','centimeters',10)
select dbo.fn_calc_uoc_length('hand','chain',10)
select dbo.fn_calc_uoc_length('hand','fathom',10)
select dbo.fn_calc_uoc_length('hand','feet',10)
select dbo.fn_calc_uoc_length('hand','inch',10)
select dbo.fn_calc_uoc_length('hand','kilometers' ,10)
select dbo.fn_calc_uoc_length('hand','link',10)
select dbo.fn_calc_uoc_length('hand','meter',10)
select dbo.fn_calc_uoc_length('hand','microns',10)
select dbo.fn_calc_uoc_length('hand','mile',10)
select dbo.fn_calc_uoc_length('hand','millimeters',10)
select dbo.fn_calc_uoc_length('hand','nanometer' ,10)
select dbo.fn_calc_uoc_length('hand','nautical miles',10)
select dbo.fn_calc_uoc_length('hand','pica',10)
select dbo.fn_calc_uoc_length('hand','rods',10)
select dbo.fn_calc_uoc_length('hand','span',10)
select dbo.fn_calc_uoc_length('hand','yard',10)

select dbo.fn_calc_uoc_length('inch','angstrom' ,10)
select dbo.fn_calc_uoc_length('inch','centimeters',10)
select dbo.fn_calc_uoc_length('inch','chain',10)
select dbo.fn_calc_uoc_length('inch','fathom',10)
select dbo.fn_calc_uoc_length('inch','feet',10)
select dbo.fn_calc_uoc_length('inch','hand',10)
select dbo.fn_calc_uoc_length('inch','kilometers' ,10)
select dbo.fn_calc_uoc_length('inch','link',10)
select dbo.fn_calc_uoc_length('inch','meter',10)
select dbo.fn_calc_uoc_length('inch','microns',10)
select dbo.fn_calc_uoc_length('inch','mile',10)
select dbo.fn_calc_uoc_length('inch','millimeters',10)
select dbo.fn_calc_uoc_length('inch','nanometer' ,10)
select dbo.fn_calc_uoc_length('inch','nautical miles',10)
select dbo.fn_calc_uoc_length('inch','pica',10)
select dbo.fn_calc_uoc_length('inch','rods',10)
select dbo.fn_calc_uoc_length('inch','span',10)
select dbo.fn_calc_uoc_length('inch','yard',10)

select dbo.fn_calc_uoc_length('kilometers','angstrom' ,10)
select dbo.fn_calc_uoc_length('kilometers','centimeters',10)
select dbo.fn_calc_uoc_length('kilometers','chain',10)
select dbo.fn_calc_uoc_length('kilometers','fathom',10)
select dbo.fn_calc_uoc_length('kilometers','feet',10)
select dbo.fn_calc_uoc_length('kilometers','hand',10)
select dbo.fn_calc_uoc_length('kilometers','inch' ,10)
select dbo.fn_calc_uoc_length('kilometers','link',10)
select dbo.fn_calc_uoc_length('kilometers','meter',10)
select dbo.fn_calc_uoc_length('kilometers','microns',10)
select dbo.fn_calc_uoc_length('kilometers','mile',10)
select dbo.fn_calc_uoc_length('kilometers','millimeters',10)
select dbo.fn_calc_uoc_length('kilometers','nanometer' ,10)
select dbo.fn_calc_uoc_length('kilometers','nautical miles',10)
select dbo.fn_calc_uoc_length('kilometers','pica',10)
select dbo.fn_calc_uoc_length('kilometers','rods',10)
select dbo.fn_calc_uoc_length('kilometers','span',10)
select dbo.fn_calc_uoc_length('kilometers','yard',10)

select dbo.fn_calc_uoc_length('link','angstrom' ,10)
select dbo.fn_calc_uoc_length('link','centimeters',10)
select dbo.fn_calc_uoc_length('link','chain',10)
select dbo.fn_calc_uoc_length('link','fathom',10)
select dbo.fn_calc_uoc_length('link','feet',10)
select dbo.fn_calc_uoc_length('link','hand',10)
select dbo.fn_calc_uoc_length('link','inch' ,10)
select dbo.fn_calc_uoc_length('link','kilometers',10)
select dbo.fn_calc_uoc_length('link','meter',10)
select dbo.fn_calc_uoc_length('link','microns',10)
select dbo.fn_calc_uoc_length('link','mile',10)
select dbo.fn_calc_uoc_length('link','millimeters',10)
select dbo.fn_calc_uoc_length('link','nanometer' ,10)
select dbo.fn_calc_uoc_length('link','nautical miles',10)
select dbo.fn_calc_uoc_length('link','pica',10)
select dbo.fn_calc_uoc_length('link','rods',10)
select dbo.fn_calc_uoc_length('link','span',10)
select dbo.fn_calc_uoc_length('link','yard',10)

select dbo.fn_calc_uoc_length('meter','angstrom' ,10)
select dbo.fn_calc_uoc_length('meter','centimeters',10)
select dbo.fn_calc_uoc_length('meter','chain',10)
select dbo.fn_calc_uoc_length('meter','fathom',10)
select dbo.fn_calc_uoc_length('meter','feet',10)
select dbo.fn_calc_uoc_length('meter','hand',10)
select dbo.fn_calc_uoc_length('meter','inch' ,10)
select dbo.fn_calc_uoc_length('meter','kilometers',10)
select dbo.fn_calc_uoc_length('meter','link',10)
select dbo.fn_calc_uoc_length('meter','microns',10)
select dbo.fn_calc_uoc_length('meter','mile',10)
select dbo.fn_calc_uoc_length('meter','millimeters',10)
select dbo.fn_calc_uoc_length('meter','nanometer' ,10)
select dbo.fn_calc_uoc_length('meter','nautical miles',10)
select dbo.fn_calc_uoc_length('meter','pica',10)
select dbo.fn_calc_uoc_length('meter','rods',10)
select dbo.fn_calc_uoc_length('meter','span',10)
select dbo.fn_calc_uoc_length('meter','yard',10)

select dbo.fn_calc_uoc_length('microns','angstrom' ,10)
select dbo.fn_calc_uoc_length('microns','centimeters',10)
select dbo.fn_calc_uoc_length('microns','chain',10)
select dbo.fn_calc_uoc_length('microns','fathom',10)
select dbo.fn_calc_uoc_length('microns','feet',10)
select dbo.fn_calc_uoc_length('microns','hand',10)
select dbo.fn_calc_uoc_length('microns','inch' ,10)
select dbo.fn_calc_uoc_length('microns','kilometers',10)
select dbo.fn_calc_uoc_length('microns','link',10)
select dbo.fn_calc_uoc_length('microns','meter',10)
select dbo.fn_calc_uoc_length('microns','mile',10)
select dbo.fn_calc_uoc_length('microns','millimeters',10)
select dbo.fn_calc_uoc_length('microns','nanometer' ,10)
select dbo.fn_calc_uoc_length('microns','nautical miles',10)
select dbo.fn_calc_uoc_length('microns','pica',10)
select dbo.fn_calc_uoc_length('microns','rods',10)
select dbo.fn_calc_uoc_length('microns','span',10)
select dbo.fn_calc_uoc_length('microns','yard',10)

select dbo.fn_calc_uoc_length('mile','angstrom' ,10)
select dbo.fn_calc_uoc_length('mile','centimeters',10)
select dbo.fn_calc_uoc_length('mile','chain',10)
select dbo.fn_calc_uoc_length('mile','fathom',10)
select dbo.fn_calc_uoc_length('mile','feet',10)
select dbo.fn_calc_uoc_length('mile','hand',10)
select dbo.fn_calc_uoc_length('mile','inch' ,10)
select dbo.fn_calc_uoc_length('mile','kilometers',10)
select dbo.fn_calc_uoc_length('mile','link',10)
select dbo.fn_calc_uoc_length('mile','meter',10)
select dbo.fn_calc_uoc_length('mile','microns',10)
select dbo.fn_calc_uoc_length('mile','millimeters',10)
select dbo.fn_calc_uoc_length('mile','nanometer' ,10)
select dbo.fn_calc_uoc_length('mile','nautical miles',10)
select dbo.fn_calc_uoc_length('mile','pica',10)
select dbo.fn_calc_uoc_length('mile','rods',10)
select dbo.fn_calc_uoc_length('mile','span',10)
select dbo.fn_calc_uoc_length('mile','yard',10)

select dbo.fn_calc_uoc_length('millimeters','angstrom' ,10)
select dbo.fn_calc_uoc_length('millimeters','centimeters',10)
select dbo.fn_calc_uoc_length('millimeters','chain',10)
select dbo.fn_calc_uoc_length('millimeters','fathom',10)
select dbo.fn_calc_uoc_length('millimeters','feet',10)
select dbo.fn_calc_uoc_length('millimeters','hand',10)
select dbo.fn_calc_uoc_length('millimeters','inch' ,10)
select dbo.fn_calc_uoc_length('millimeters','kilometers',10)
select dbo.fn_calc_uoc_length('millimeters','link',10)
select dbo.fn_calc_uoc_length('millimeters','meter',10)
select dbo.fn_calc_uoc_length('millimeters','microns',10)
select dbo.fn_calc_uoc_length('millimeters','mile',10)
select dbo.fn_calc_uoc_length('millimeters','nanometer' ,10)
select dbo.fn_calc_uoc_length('millimeters','nautical miles',10)
select dbo.fn_calc_uoc_length('millimeters','pica',10)
select dbo.fn_calc_uoc_length('millimeters','rods',10)
select dbo.fn_calc_uoc_length('millimeters','span',10)
select dbo.fn_calc_uoc_length('millimeters','yard',10)

select dbo.fn_calc_uoc_length('nanometer','angstrom' ,10)
select dbo.fn_calc_uoc_length('nanometer','centimeters',10)
select dbo.fn_calc_uoc_length('nanometer','chain',10)
select dbo.fn_calc_uoc_length('nanometer','fathom',10)
select dbo.fn_calc_uoc_length('nanometer','feet',10)
select dbo.fn_calc_uoc_length('nanometer','hand',10)
select dbo.fn_calc_uoc_length('nanometer','inch' ,10)
select dbo.fn_calc_uoc_length('nanometer','kilometers',10)
select dbo.fn_calc_uoc_length('nanometer','link',10)
select dbo.fn_calc_uoc_length('nanometer','meter',10)
select dbo.fn_calc_uoc_length('nanometer','microns',10)
select dbo.fn_calc_uoc_length('nanometer','mile',10)
select dbo.fn_calc_uoc_length('nanometer','millimeters' ,10)
select dbo.fn_calc_uoc_length('nanometer','nautical miles',10)
select dbo.fn_calc_uoc_length('nanometer','pica',10)
select dbo.fn_calc_uoc_length('nanometer','rods',10)
select dbo.fn_calc_uoc_length('nanometer','span',10)
select dbo.fn_calc_uoc_length('nanometer','yard',10)

select dbo.fn_calc_uoc_length('nautical miles','angstrom' ,10)
select dbo.fn_calc_uoc_length('nautical miles','centimeters',10)
select dbo.fn_calc_uoc_length('nautical miles','chain',10)
select dbo.fn_calc_uoc_length('nautical miles','fathom',10)
select dbo.fn_calc_uoc_length('nautical miles','feet',10)
select dbo.fn_calc_uoc_length('nautical miles','hand',10)
select dbo.fn_calc_uoc_length('nautical miles','inch' ,10)
select dbo.fn_calc_uoc_length('nautical miles','kilometers',10)
select dbo.fn_calc_uoc_length('nautical miles','link',10)
select dbo.fn_calc_uoc_length('nautical miles','meter',10)
select dbo.fn_calc_uoc_length('nautical miles','microns',10)
select dbo.fn_calc_uoc_length('nautical miles','mile',10)
select dbo.fn_calc_uoc_length('nautical miles','millimeters' ,10)
select dbo.fn_calc_uoc_length('nautical miles','nanometer',10)
select dbo.fn_calc_uoc_length('nautical miles','pica',10)
select dbo.fn_calc_uoc_length('nautical miles','rods',10)
select dbo.fn_calc_uoc_length('nautical miles','span',10)
select dbo.fn_calc_uoc_length('nautical miles','yard',10)

select dbo.fn_calc_uoc_length('pica','angstrom' ,10)
select dbo.fn_calc_uoc_length('pica','centimeters',10)
select dbo.fn_calc_uoc_length('pica','chain',10)
select dbo.fn_calc_uoc_length('pica','fathom',10)
select dbo.fn_calc_uoc_length('pica','feet',10)
select dbo.fn_calc_uoc_length('pica','hand',10)
select dbo.fn_calc_uoc_length('pica','inch' ,10)
select dbo.fn_calc_uoc_length('pica','kilometers',10)
select dbo.fn_calc_uoc_length('pica','link',10)
select dbo.fn_calc_uoc_length('pica','meter',10)
select dbo.fn_calc_uoc_length('pica','microns',10)
select dbo.fn_calc_uoc_length('pica','mile',10)
select dbo.fn_calc_uoc_length('pica','millimeters' ,10)
select dbo.fn_calc_uoc_length('pica','nanometer',10)
select dbo.fn_calc_uoc_length('pica','nautical miles',10)
select dbo.fn_calc_uoc_length('pica','rods',10)
select dbo.fn_calc_uoc_length('pica','span',10)
select dbo.fn_calc_uoc_length('pica','yard',10)

select dbo.fn_calc_uoc_length('rods','angstrom' ,10)
select dbo.fn_calc_uoc_length('rods','centimeters',10)
select dbo.fn_calc_uoc_length('rods','chain',10)
select dbo.fn_calc_uoc_length('rods','fathom',10)
select dbo.fn_calc_uoc_length('rods','feet',10)
select dbo.fn_calc_uoc_length('rods','hand',10)
select dbo.fn_calc_uoc_length('rods','inch' ,10)
select dbo.fn_calc_uoc_length('rods','kilometers',10)
select dbo.fn_calc_uoc_length('rods','link',10)
select dbo.fn_calc_uoc_length('rods','meter',10)
select dbo.fn_calc_uoc_length('rods','microns',10)
select dbo.fn_calc_uoc_length('rods','mile',10)
select dbo.fn_calc_uoc_length('rods','millimeters' ,10)
select dbo.fn_calc_uoc_length('rods','nanometer',10)
select dbo.fn_calc_uoc_length('rods','nautical miles',10)
select dbo.fn_calc_uoc_length('rods','pica',10)
select dbo.fn_calc_uoc_length('rods','span',10)
select dbo.fn_calc_uoc_length('rods','yard',10)

select dbo.fn_calc_uoc_length('span','angstrom' ,10)
select dbo.fn_calc_uoc_length('span','centimeters',10)
select dbo.fn_calc_uoc_length('span','chain',10)
select dbo.fn_calc_uoc_length('span','fathom',10)
select dbo.fn_calc_uoc_length('span','feet',10)
select dbo.fn_calc_uoc_length('span','hand',10)
select dbo.fn_calc_uoc_length('span','inch' ,10)
select dbo.fn_calc_uoc_length('span','kilometers',10)
select dbo.fn_calc_uoc_length('span','link',10)
select dbo.fn_calc_uoc_length('span','meter',10)
select dbo.fn_calc_uoc_length('span','microns',10)
select dbo.fn_calc_uoc_length('span','mile',10)
select dbo.fn_calc_uoc_length('span','millimeters' ,10)
select dbo.fn_calc_uoc_length('span','nanometer',10)
select dbo.fn_calc_uoc_length('span','nautical miles',10)
select dbo.fn_calc_uoc_length('span','pica',10)
select dbo.fn_calc_uoc_length('span','rods',10)
select dbo.fn_calc_uoc_length('span','yard',10)

select dbo.fn_calc_uoc_length('yard','angstrom' ,10)
select dbo.fn_calc_uoc_length('yard','centimeters',10)
select dbo.fn_calc_uoc_length('yard','chain',10)
select dbo.fn_calc_uoc_length('yard','fathom',10)
select dbo.fn_calc_uoc_length('yard','feet',10)
select dbo.fn_calc_uoc_length('yard','hand',10)
select dbo.fn_calc_uoc_length('yard','inch' ,10)
select dbo.fn_calc_uoc_length('yard','kilometers',10)
select dbo.fn_calc_uoc_length('yard','link',10)
select dbo.fn_calc_uoc_length('yard','meter',10)
select dbo.fn_calc_uoc_length('yard','microns',10)
select dbo.fn_calc_uoc_length('yard','mile',10)
select dbo.fn_calc_uoc_length('yard','millimeters' ,10)
select dbo.fn_calc_uoc_length('yard','nanometer',10)
select dbo.fn_calc_uoc_length('yard','nautical miles',10)
select dbo.fn_calc_uoc_length('yard','pica',10)
select dbo.fn_calc_uoc_length('yard','rods',10)
select dbo.fn_calc_uoc_length('yard','span',10)