var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need Help with Picture String
I have a field called MacAddr. It is a varchar(12). In my report, I want to show it as 'XX-XX-XX-XX-XX-XX'. I don't know how. 'lil hep? Thanks
Is there a format that'll do it easily? Can't remember at the moment ... but this might work:
SELECT REPLACE(TO_CHAR(macaddr, '99,99,99,99,99,99'), ',', '-') FROM your_table;
Yes, but a MAC Addr is defined as a varchar(12) and contains Alphanumeric characters because if is a HEX number such as 000BCDF592B2. I would like my output to display:
Last edited by Book; 11-03-05 at 10:09.
maybe a bit uncomfortable, but what can you do...
substr(macaddr,1,2) || '-' || substr(macaddr,3,2) || '-' || substr(macaddr,5,2) || '-' || substr(macaddr,7,2) || '-' || substr(macaddr,9,2) || '-' || substr(macaddr,11,2)
Uncomfortable, perhaps, but, effective.