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 [from int] [for int]) -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general