Selektovanje samo prvog slova iz polja

18.01.2012. u 08:50 · pre 179 meseci

Da li je moguće selektovati samo prvo slovo iz nekog polja?

Imam upit

Code:
SELECT p.company, lower(trim(p.fname)), lower(trim(p.lname)) FROM profile p

Ne treba mi celo prezime, već samo prvo slovo prezimena, nešto kao lower(trim(p.lname[0]))?

Hvala

18.01.2012. u 09:59 · pre 179 meseci

SELECT p.company, lower(trim(substr((p.fname, 1, 1))), lower(trim(p.lname)) FROM profile p;

http://psoug.org/reference/substr_instr.html

Potpis

I've seen things you people wouldn't believe. Attack ships on fire off the shoulder of Orion. I watched C-beams glitter in the dark near the Tannhauser gate. All those moments will be lost in time, like tears in rain. Time to die.

Srodne teme