formatting

[cptkirkh]

I have a SQL query with a select statement like this..

lpad(cli_rid,7,'0')||
RPAD(nvl(CLI_PREFIX||' '||CLI_FIRST_NAME||' '||CLI_LAST_NAME||' '||CLI_SUFFIX,' '),40)||
RPAD(nvl(CLI_DESIGNATIONS,' '),27)||
RPAD(nvl(MAD_AGENCY_NAME,' '),45)||
RPAD(nvl(MAD_ADDRESS,' '),80)||
RPAD(nvl(MAD_CITY,' '),20)||
RPAD(nvl(MAD_STATE,' '),2)||
RPAD(nvl(MAD_ZIP||decode(MAD_ZIP_PLUS,NULL,'','-')||MAD_ZIP_PLUS,' '),10) text

how do I format the output to give me all of the select statement? It stops right after the agency name?