• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Select Users Whose Last Name Falls in Alphabet Range

I have a page from which users can select to produce a PDF file of the attendance sheet.

I can select users by profession. I would like the user to also be able to narrow down each sign in sheet by first letter of last name. So they can select the letter A and the letter K to get all the people who signed up for the workshop whose last name's first letter falls in the range between A and K.

Any suggestions?
1 Solution
Olaf DoschkeSoftware DeveloperCommented:
sql: select * from attendees where lower(left(lastname,1)) between 'a' and 'k'
gianchi66Author Commented:
I guess it wasn't that hard... but I had never done it!

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now