clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3798699 fiddles created (41869 in the last week).

select concat(substring(cast(cast(1234.00 as decimal(10,2)) as varchar(50)),1, position('.' in cast(cast(1234.00 as decimal(10,2)) as varchar(50)))-1),' ft') as Length
length
1234 ft
 hidden batch(es)