Skip site navigation (1) Skip section navigation (2)

Re: Concatenating strings

From: Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in>
To: Fredrik Thunberg <fredrik(at)datessa(dot)se>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Concatenating strings
Date: 2001-10-23 12:08:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

standard function  initcap() should do the job. May be , first you need
to do  lower()
and then do initcap().

You can add two columns   col1||col2

Syntax of substring is like substring($string from pos for len)


Fredrik Thunberg wrote:
> Hi all.
> How do you add two strings in sql?
> I have a name field in one of my tables and all the names are in uppercase
> (like "FREDRIK").
> I want to get the names in the usual format (First letter capitalized)
> "Fredrik". How
> do I do that?

In response to

pgsql-novice by date

Next:From: Chr. RossmanithDate: 2001-10-23 12:13:23
Subject: Re: Problem with createdb & case (7.1.3)
Previous:From: Fredrik ThunbergDate: 2001-10-23 09:10:57
Subject: Concatenating strings

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group