Find candidate having experience greater than 2 from string value in SQL Server

Hi mukesh1,

Check below Query.

Note: You need to save the record in Year and Months format in DataBase as like below.

It is better if you can save in Numeric Format instead of String.

SQL

DECLARE @Test AS TABLE (Experience VARCHAR(50))
INSERT INTO @Test VALUES('1 Yr 9 Months')
INSERT INTO @Test VALUES('2 Yr 1 Months')
INSERT INTO @Test VALUES('5 Yr')

SELECT * FROM @Test WHERE SUBSTRING(Experience,1,2) > 1

Output

Experience

2 Yr 1 Months

5 Yr