Skip to main content
A
adamantics
Participant
May 17, 2006
Question

name starts with a-e

  • May 17, 2006
  • 3 replies
  • 353 views
hopefully this is an easy one...

I want my query to only display records from my staff list where their first name starts with letters a - e

cheers
This topic has been closed for replies.

3 replies

A
adamanticsAuthor
Participant
May 18, 2006
thanks - worked perfectly
D
Dan_Bracuk
Inspiring
May 17, 2006
It's an easy one if you are storing the first and last names in separate fields. Depending on the db, and the possibility of a name being stored in lower case, you might want to add an upper function to jdeline's answer.
A
Anonymous
May 17, 2006
SELECT * FROM myTable WHERE lastName < 'F'
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices