psql function to get substring from the last capital letter in a main string

[sivaroyal]

For example: main String==> "FirstSecondThi rd"


from the above string I need "Third" only.



Can any help Pls.........

[Rabbit]

You'll have to create a function to look at the ascii codes looking for the third capital. There's nothing built in that will do that for you.