Wanda > You can also do: > select substr(filespace_name,1,20) from filespaces > > and get only 20 chars back.
Well that's interesting because it makes the problem worse! Using either CAST or SUBSTR truncate my data to N characters, but CAST gives me a column width of (N+1) for NODE_NAME and (2N+1) for FILESPACE_NAME, whereas SUBSTR gives me a column width of (2N+1) for both NODE_NAME and FILESPACE_NAME. What I was actually aiming for was a column width (ie the number of '-' characters that underline the column heading) of only N+1 for both FILESPACE_NAME and NODE_NAME. tsm: xxxxxxx>select substr(filespace_name,1,20) as FS, substr (filespace_name,1,10) as Node from filespaces FS NODE ----------------------------------------- --------------------- \\xxxxxxxxxx\w$ xxxx xxxxxxxxxx\SystemSta xxxxxxxxxx ASR xxxxxxxxxx \\xxxxxxxxxx\c$ xxxxxxxxxx \\xxxxxxxxxx\d$ xxxxxxxxxx \\xxxxxxxxxx\e$ xxxxxxxxxx \\xxxxxxxxxx\f$ xxxxxxxxxx \\xxxxxxxxxx\g$ xxxxxxxxxx xxxxxxx\xxxx\meta\00 xxxxxxxxxx ... tsm: xxxxxxx>select cast(filespace_name as char(20)) as FS, cast(node_name as char(10)) as Node from filespaces FS NODE)) ----------------------------------------- ----------- \\xxxxxxxxxx\w$ xxxx xxxxxxxxxx\SystemSta xxxxxxxxxx ASR xxxxxxxxxx \\xxxxxxxxxx\c$ xxxxxxxxxx \\xxxxxxxxxx\d$ xxxxxxxxxx \\xxxxxxxxxx\e$ xxxxxxxxxx \\xxxxxxxxxx\f$ xxxxxxxxxx \\xxxxxxxxxx\g$ xxxxxxxxxx xxxxxxx\xxxx\meta\00 xxxxxxxxxx ... Regards Neil ---------------------------------------- Spotted a leak? If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to http://www.yorkshirewater.com/leaks Get a free water saving pack Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water. http://www.yorkshirewater.com/savewater The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in England and Wales No 2366682
