SQL LIKE Question 1

[powahusr]

I created a simple query that retrieves a group of records based on the first character of the last name specified in the Select Statement, like such:

SELECT EmployeeID, LastName, FirstName
FROM Employee
WHERE LName LIKE 'a%'

However, what I'm really looking to do is retrieve all records based on what letters I specify in the SELECT statement. If I wanted to retrieve all records for people with the last name that start with A, B, C, AND D. How would I tweak the preceding SQL statement to retrieve all matching records that the last name starts with A, B, C, AND D?

Thanks in advance!!!

 

[r937]

 where LName < 'E'

there are other ways, but that's the easiest


rudy

http://rudy.ca/

 

[powahusr]

Worked Great! Thanks!

 

[stoggers]

Hi,

Just a word of warning....

If the column only contains alphabetic characters then using '<' will probably work but be aware that:

spc ! &quot; # $ % & ' ( ) * + , - . /
0 1 2 3 4 5 6 7 8 9 : ; < > ? @

are all less then 'A' in ASCII

and

spc ¢ . < ( + ! $ * ) ; | & , % _ > ?
- / : # @ ' = &quot; a b c d e f g h i
j k l m n o p q r s t u v w x y z

are all less than 'A' in EBCDIC

Regards,

Stoggers.