Take a look at LIKE or ILIKE
kd
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Kevin Duffy
Sent: Friday, November 21, 2008 11:31 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] function - string ends with
Hello All:
Is anyone aware of a function in PgSQL that will check if a string ends with a specific string?
I.e. rposition(substring in string ) returns int
Starts searching right to left within string
Thanks for your attention to this matter.
Kevin Duffy