I have a height field that contains two numeric values and I need to add ' and " at the end of each number to display the value as height(inch) format. It seemed simple but couldn't find answers that I was looking for.
Height -> Height(inch)
72 -> 7'2"
65 -> 6'5"
68 -> 6'8" . . . . . . . .
Any suggestions? I am very new to sql and and would appreciate any help I can get!!