SQL LIKE operator Search for a range of characters
Example
Following statement matches all records having FName that starts with a letter from A to F from Employees Table.
SELECT * FROM Employees WHERE FName LIKE '[A-F]%'
Following statement matches all records having FName that starts with a letter from A to F from Employees Table.
SELECT * FROM Employees WHERE FName LIKE '[A-F]%'
