CASE Clause( WHEN THEN )

See more:

SQL-Server-2005

SQL-Server

Hi,
I am have one sp and in this sp i am trying to use when then when i use when statement in this i checked column1 =3 then i want to write another qury so can i write if yes how i am giving example to understand my problem sea

DECLARE @CharGender Char(1),
	@Gender  Varchar(20);
SET @CharGender = 'F';
SET @Gender = 
	CASE @CharGender
		WHEN N'm' THEN N'Male'---(i want to another select statement here can i write in THEN)
		WHEN N'M' THEN N'Male'
		WHEN N'f' THEN N'Female'
		WHEN N'F' THEN N'Female'
	END;