[RESOLVED] Multiple selects in Stored Procedure

[venerable bede]

SQL SERVER 2008

I have a table "tbl1" and I would like to query the table 3 times.

e.g

Select MyVal from tbl1 where Title like 'Fred%'
Select MyVal from tbl1 where Title like 'Jane%'
Select MyVal from tbl1 where Title like 'Jimmy%'

I want to put these 3 selects into a stored procedure to return 3 values :

declare @MyVal1 
declare @MyVal2 
declare @MyVal3

Select @MyVal1 from tbl1 where Title like 'Fred%'
Select @MyVal2 from tbl1 where Title like 'Jane%'
Select @MyVal3 from tbl1 where Title like 'Jimmy%'

I think I'm confusing myself a bit here.
Is this possible and whats the syntax?

Thanks In Advance