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