the first X chars of a varchar column?
Hi all;
I'm selecting from a table that has a varchar(1000) but I only want to
display
the firs 20 characters. Looked at the string functions in the docs but
nothing
jumped out...
Suggestions?
Thanks in advance
--
Sent via pgsql-general mailing list
Hi all;
I'm selecting from a table that has a varchar(1000) but I only want to display
the firs 20 characters. Looked at the string functions in the docs but nothing
jumped out...
Suggestions?
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Monday 31 August 2009 7:49:12 am Kevin Kempter wrote:
Hi all;
I'm selecting from a table that has a varchar(1000) but I only want to
display the firs 20 characters. Looked at the string functions in the docs
but nothing jumped out...
Suggestions?
Thanks in advance
substring(string