formatting column in sql

Im tring to set a column format for a rather large column.

COLUMN '<AHREF="REPORT'||SYSDATE||'.HTML#'||A.US_ID||'">' HEADING link

select '<a href="report'||sysdate||'.html#'||a.us_id||'">', a.first_name||' '||a.last_name||'</a>',
a.phone_area||'-'||a.phone_exchange||'-'||a.phone_line, b.vaccination_date, c.name, d.occupation_desc||'<br>'

    from patients a, vaccines b, organizations c, occupations d, pat_adult_info e

    where e.us_id = a.us_id and e.occupation_code = d.occupation_code(+) and c.org_id(+) = b.refer_org_id and a.patient_id = b.patient_id and b.vaccine_code = 75;

is the query but the first returns

SQL> COLUMN '<A HREF="REPORT'||SYSDATE||'.HTML#'||A.US_ID||!'">' HEADING link
SP2-0735: unknown COLUMN option beginning "||SYSDATE|..."

I tried setting the escape to '/' and then putting that in front of all the ' in the column command but that doesn't seem to work, any ideas?

TIA Received on Thu Oct 14 2004 - 11:52:43 CDT