Advertisement
Guest User

SQL - Find patrons with 2 last names

a guest
Oct 12th, 2022
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT LENGTH(b.surname) - LENGTH(REPLACE(b.surname, ' ', ''))+1 as mycheck, b.surname, b.firstname, b.borrowernumber
  2. FROM borrowers b
  3. WHERE
  4. (SELECT LENGTH(b.surname) - LENGTH(REPLACE(b.surname, ' ', ''))+1)>1
  5. AND b.branchcode = 'RCPL'
  6. AND b.categorycode != 'ILL'
  7. AND b.dateexpiry > <<Yesterday|date>>
  8. ORDER BY b.surname
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement