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: 3BD55DD5.3605498@giaspn01.vsnl.net.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi

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)

Vijay

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

Browse pgsql-novice by date

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