Re: Concatenating strings - Mailing list pgsql-novice

From Vijay Deval
Subject Re: Concatenating strings
Date
Msg-id 3BD55DD5.3605498@giaspn01.vsnl.net.in
Whole thread Raw
In response to Concatenating strings  ("Fredrik Thunberg" <fredrik@datessa.se>)
List 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?
>



pgsql-novice by date:

Previous
From: Francisco Solari
Date:
Subject: Re: List of data bases
Next
From: Tom Lane
Date:
Subject: Re: Concatenating strings