Try this:
select substr(column_name,1,10) from table_name;
the substr() has 1 for the starting point and 10
as the number of char to display.
if my table was address with name varchar2(100) and
city varchar2(200) I would do
select substr(name,1,15) from address;
display only the first 15 char of name to the output.
Good luck.
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Wed Nov 03 1999 - 11:51:54 CST
