Take a look at LIKE or ILIKE
kd
________________________________
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Kevin Duffy
Sent: Friday, November 21, 2008 11:31 AM
To: pgsql-sql(at)postgresql(dot)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