Convert height in inches to feet and inches 1

[timscronin]

Has anyone attempted to convert in TSQL inches to Feet and inches. For example take 74 inches and convert to 6ft 2 inches? I was thinking about a case but that seems a little cumbersome

 

[JohnDTampaBay]

I don't think you need a CASE statement. How does this work for you? HTH, Good luck!

DECLARE @inches int
SET @inches = 74

SELECT CAST((@inches / 12) AS varchar(10)) + ' ft '
       + CAST((@inches % 12) AS varchar(10)) + ' in'

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[timscronin]

thanks works great, just out of curiousity, what does the
%12 do?

 

[JohnDTampaBay]

The percent sign is the modulo operator. It returns the remainder of a division operation. If you divide 74 by 12 the modulo is 2.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)