extension joomla, template joomla,banner extension joomla,jomla slider,slider joomla
Conversion of Imperial to Metric System in SQL Server 2008

There will be case when you need to convert the values in Imperial system i.e. in feet and inches to the one in metric system. The conversion logic seems simple, but when it comes to SQL Server, it takes a bit complex.

Here is the function which can convert imperial unit of measurement to the metric system.

Run the following SQL Query to test the results:-

SELECT [dbo].fncImperialToMetric (‘5” 10″‘),[dbo].fncImperialToMetric (‘5” 2’),

[dbo].fncImperialToMetric (‘5”’),

[dbo].fncImperialToMetric (’10’),

[dbo].fncImperialToMetric (’10″‘)


The results are:-



Related Article

destination source:https://www.programming-techniques.com/2012/06/conversion-of-imperial-to-metric-system-in-sql-server-2008.html