I am using a function in a select statement (saturn_midd.stud_adm_util_miis_pkg.get_email_address(srbrecr_pidm)
It is returning the right results but I am trying to line up correctly, it seems that if value before is null it will move the email
the output, the email should be lining up
00468474 Mr. Eamonn Gallagher 200998 QIPU CMQ LSWA LSAK ejg08@hampshire.edu
00469714 Ms. Ly Le P.O. Box 7907, Farin Easton PA 18042 200998 QIPU CMQ L ms098@yahoo.com
Can I do this in a function
RPAD(NVL(saturn_midd.stud_adm_util_miis_pkg.get_email_address(srbrecr_pidm),' ',50, ' ') email_address,
I am using the RPAD function like this
CASE
WHEN spraddr_atyp_code = 'CR'
AND spraddr_atyp_code != 'CM'
THEN RPAD (NVL (spraddr_zip, ' '), 8, ' ')
END zip1,
CASE
WHEN spraddr_atyp_code = 'CR'
AND spraddr_atyp_code != 'CM'
THEN RPAD (NVL (spraddr_cnty_code, ' '), 8, ' ')
END cnty_code1,
CASE
WHEN spraddr_atyp_code = 'CR'
AND spraddr_atyp_code != 'CM'
THEN RPAD(NVL(spraddr_natn_code, ' '), 8,' ' )
Edited by: user648177 on Apr 28, 2009 10:33 AM
Edited by: user648177 on Apr 28, 2009 10:33 AM