SQL SERVER CHOOSE FORMULA TO SELECT AN OPTION FROM A LIST OF VALUES

SQL SERVER CHOOSE FORMULA TO SELECT AN OPTION FROM A LIST OF VALUES

Select CHOOSE(5,'mdx','regex','js','html','sql');

/* CREATE STORED PROCEDURE FOR CHOOSE FORMULA */

CREATE PROCEDURE CHOOSE1 AS
BEGIN
DECLARE @A AS INT
SET @A=2
Select CHOOSE(@A,'mdx','regex','js','html','sql')
END;

/* EXECUTE CHOOSE PROCEDURE */

EXECUTE CHOOSE1;

/* DROP CHOOSE PROCEDURE */

DROP PROCEDURE CHOOSE1;