Rather long solution .. but it works...
If someone out there can write a condensed SQL that will nail this I'd be happy to buy ....

My SQL may...

One more time... Let me make my issue  clear.
Please help me write SQl that will give me the following output:

ANO NOW HERE IS THE SQL ... So...

Thanks... I figured....
No further responses or support needed......
Thank you for your effort.

Declare @C CHAR(1);
Select @C='1'

IF OBJECT_ID('tempdb..#t') IS NOT...

Mr Thom
I tried and it failed... That is why I asked you 

Declare @C CHAR(1);
Select @C='3'

IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE...

All Set Now !  Thx
I also had forgotten to create a variable. Did that ( see pic below ) 
and then like you mentioned, I added it to the References and...

Phil
Thanks, Take a look at the attached pic. Am i missing something here. I did it the way you mentioned and now it doe snot allow me to select a...