Re: Substring from end of string

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tille, Andreas
> Sent: Thursday, May 23, 2002 4:12 AM
> To: PostgreSQL General
> Subject: [GENERAL] Substring from end of string
>
>
> Hello,
>
> I have to port a MS SQL implemented application. There is a string
> function called "Right(string,num)" which returns num characters
> from the end of the string.
>
> I did nout found something in functions-string.html which might
> fit for this purpose.
>
> Any hint?
>
> Kind regards

To find the last 3 characters of a:

substring ( a from length (a) - 2 );

- J.

Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant