Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2014
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT INITCAP(DEPT) "Dept_Name",
  2. LENGTH(DEPT) "Length"
  3. FROM TEMP_ITEM
  4. WHERE DEPT LIKE 'P%'
  5. OR DEPT LIKE 'Q%'
  6. OR DEPT LIKE 'R%'
  7. OR DEPT LIKE 'S%'
  8. ORDER BY DEPT DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement