Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT INITCAP(nazwisko)||' '||INITCAP(imie1) osoba, SUBSTR(UPPER(nazwisko),1,1)||'.'||SUBSTR(UPPER(imie1),1,1)||'.' inicjaly, LENGTH(nazwisko)+LENGTH(imie1) dlugosc
  2. FROM Osoby
  3. WHERE LENGTH(imie1)+LENGTH(nazwisko)>5;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement