In a table column, I have this address value:

"Muehlgasse 1 86637 Wertingen GERMANY"

I want to get only the GERMANY part on my SELECT code. I’ve tested this code:

SELECT right('Muehlgasse 1 86637 Wertingen GERMANY',7)

It works, but the ’7′ has to be calculated, because we have other countries, too.

Any idea?? Thanks