harsha547
3/26/2017 - 11:29 PM

Employee with first name starts in between A-N

Employee with first name starts in between A-N

-- Emplyees with First name starts in between A-N
 
SELECT Employees.FirstName 
	FROM dbo.Employees
	WHERE FirstName LIKE '[A-N]%'

-- Use caret symbol to find opposite of employees doesn't start with A-N

SELECT Employees.FirstName 
	FROM dbo.Employees
	WHERE FirstName LIKE '[^A-N]%'
  
  -- Linkedin Profile : https://www.linkedin.com/in/harshasannareddy/