Let me explain a little bit more.
I have a variable (@lang) that has the countrycode for the particular language.
I take @lang from the inserted values, this works fine.
What I then want is the particular strings in the choosen language from the table lang_strings.
The lang_strings table has the following columns (NAME, EN,SV,FR,ES....an more) and for this example above, lets say that the user has choosen 'EN' as the language
If I try the one you gave me above:
set @subject_String=(select @lang from lang_strings where name = 'subject'
@lang contains 'EN' but If I later print out @subject_string the entire statement becomes 'EN'
I've looked in BOL and it seems that I can only use variables in the where clause, not in the select clause...is this correct?
Does anyone know another way?