Hi John
This is what I tried:
DECLARE @TEXT varchar(50)
SELECT @TEXT = 'HELLO'
SET LANGUAGE 'Spanish'
SELECT @TEXT
It just gives me back 'HELLO'.
I thought about storing the messages in a text and just pulling them but I was hoping I might be able to do it on the fly