Hi, I apologize for not understanding, but why would I want to send all 3 columns? I just want to return the 1 column that is the language they are...

Thanks Journeyman, I replaced the case with an if statement and it worked. However, when I call it in my stored procedure it fails? Code below:

CREATE PROCEDURE [MySp]

@RequestedLangage varchar

AS

SELECT...

Hi guys, I'm trying to use the function, but when I embed the CASE statement the syntax fails. Could someone let me know what I'm formatting wrong? Thanks.

CREATE FUNCTION [MyFunction]...

Thanks for the reply. I assume that I can just embed the "Case" statement right into the SP select line?

If I was to place the code in a function,...