Thank you all for the prompt responses. Damn, you guys are good

Thank you ! This worked. Much appreciated it

Thank you for this but the problem is that I'm working with a table that has over 80 columns and I was thinking if there's an different, easyer way to...

well, this should work

declare @Tomax decimal(18,2)

set @Tomax=(select max(height) from @T)

set @FROM =isnull(@FROM,0)

set @tO=isnull(@tO, Tomax)

select *

from @T

where height between @FROM and @tO

If you need to round...