[Q] Formatting query results

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/04/28
Message-ID: <3nrfum$35g_at_ixnews2.ix.netcom.com>#1/1


Is there a way to override the default column width in a result set? For example I want to display "last name, first name" with...

select fname||', '||lname "Full Name" from people;

But that gives me a column that's 42 characters wide. I'd rather set it to something around 30 characters so I can fit more columns accrossed the page. How do I do it?

-- 

><> Chuck Hamilton <><
><> chuckh_at_ix.netcom.com <><
Received on Fri Apr 28 1995 - 00:00:00 CEST

Original text of this message