Re: limit characters returned by a select statement

SELECT SUBSTR(mycolumn,1,mylimit) FROM mytable;

For example,

SELECT SUBSTR(ppf.last_name,1,16) FROM per_people_f ppf;

Dave wrote:

> is there a way, through sql, to limit the number of characters
> returned by a sql statement for a given column?
Received on Tue Oct 30 2001 - 08:37:46 CST