Skip to content

Instantly share code, notes, and snippets.

@lkrych

lkrych/upper.rb

Created April 5, 2018 16:26
Show Gist options
  • Save lkrych/ad7267b9afe182b720ae6a23a6983c4f to your computer and use it in GitHub Desktop.
Save lkrych/ad7267b9afe182b720ae6a23a6983c4f to your computer and use it in GitHub Desktop.
Download ZIP
Demonstrating the use of the UPPER function in SQL
Raw
upper.rb
# people is some subset from the Persons table
people = people.where("UPPER(first_name) = UPPER(?) OR UPPER(last_name) = UPPER(?)", params[:fname], params[:lname])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment