• 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