[Solved] Use BETWEEN Clause for VARCHAR datatype in SQL Server

Here I have created sql script that full-fill your requirement.

SQL

DECLARE @Heigth AS TABLE(Heigth VARCHAR(10))

INSERT INTO @Heigth VALUES
('4ft5in'),
('4ft6in'),
('4ft7in'),
('4ft8in'),
('4ft9in'),
('4ft10in'),
('4ft11in'),
('5ft0in'),
('5ft1in'),
('5ft2in'),
('5ft3in'),
('5ft4in'),
('5ft5in'),
('5ft6in'),
('5ft7in'),
('5ft8in'),
('5ft9in'),
('5ft10in'),
('5ft11in')

DECLARE @FromHeigth VARCHAR(10)
DECLARE @ToHeigth VARCHAR(10)

SET @FromHeigth = '4ft5in'
SET @ToHeigth = '4ft9in'

SELECT Heigth FROM @Heigth 
WHERE CAST(REPLACE(REPLACE(Heigth,'ft',''),'in','') AS INT) BETWEEN CAST(REPLACE(REPLACE(@FromHeigth,'ft',''),'in','') AS INT)
AND CAST(REPLACE(REPLACE(@ToHeigth,'ft',''),'in','') AS INT)

Screenshot