Link to home
Start Free TrialLog in
Avatar of vd
vd

asked on

SQL - Reduce column width in select statement

Is there a way in a SELECT statement that I can specify
how wide I want the display of a column to be? In other words,
I have several columns that are 50 positions wide (because
they are defined as char 50 ) but I want to display only the
first 10 positions. I obviously don't want to change the
size of the column in the table.  
ASKER CERTIFIED SOLUTION
Avatar of jboyd
jboyd

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vd
vd

ASKER

Excellent. Thanks.