This works fine
create table yourTableName(minexperience nvarchar(max), maxexperience nvarchar(max))
insert into yourTableName
select 1, 4
union all select 2, 5
union all select 1, 3
union all select 8, 9
declare @minexp nvarchar(max) = 8,
@maxexp nvarchar(max) = 9
select *from yourTableName where minexperience >= @minexp and maxexperience <= @maxexp
we get the output as
minexperience maxexperience
---------------- ----------------
8 9