No Result From Stored Procedure

Hello evry1.

i m new to SQL Server2000. plzz tell me where i m

wrong in this SP . this procedure is not giving any

error but it is not showing any result. plzz help me n

give me any idea if u know how  i can solve my problem

best regards

sadaf

n here is the procedure





CREATE PROCEDURE Search12

(      @signup      char(50),  

      @user_name1       [char](50),

      @gender1       [char](6),

        @place1       [char](100),

      @email_address1       [char](50),

      @relegion1       [char](50),

      @political_view1       [char](50),

      @passion1       [varchar](150),

      @sports1       [varchar](150),

      @activities1       [varchar](150),

      @books1       [varchar](150),

      @music1       [varchar](150),

      @tv_shows1       [varchar](150),

      @movies1       [varchar](150),

      @cuisines1       [varchar](150),

      @intrested_in1       [varchar](150),

      @education1       [char](100),

      @college_university1       [char](50),

      @occupation1       [char](50),

      @industry1       [char](50),

      @job_desc1       [char](50),

      @career_intrest1       [char](100),

        @latitude1       [decimal],

      @longitude1       [decimal])

AS

if (@user_name1 is not null and  len(@user_name1) > 0)



begin

select * from [profile] where [user_name] like

'%@user_name1%' and place like '%@place%' and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@gender1 is not null and len(@gender1) > 0)

begin

select * from [profile] where gender = @gender1 and

place like '%@place%' and latitude=@latitude1 and

longitude=@longitude1 and signup_name != @signup;

end

if(@email_address1 is not null and

len(@email_address1) > 0)

begin

select * from [profile] where [email-address] like

'%@email_address1%' and place like '%@place%' and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if(@relegion1 is not null and len(@relegion1) > 0)

begin

select * from [profile] where relegion = @relegion1

and place like '%@place%'  and latitude=@latitude1 and

longitude=@longitude1 and signup_name != @signup;

end

if (@political_view1 is not null and

len(@political_view1) > 0)

begin

select * from [profile] where political_view =

@political_view1 and place like '%@place%' and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@passion1 is not null and len(@passion1) > 0)

begin

select * from [profile] where passion like

'%@passion1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if(@sports1 is not null and len(@sports1)  > 0)

begin

select * from [profile] where sports like '%@sports1%'

and place = @place1 and latitude=@latitude1 and

longitude=@longitude1 and signup_name != @signup;

end

if (@activities1 is not null and len(@activities1) >

0)

begin

select * from [profile] where activities like

'%@activities%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@books1 is not null and len(@books1)  > 0)

begin

select * from [profile] where books like '%books1%'

and place = @place1 and latitude=@latitude1 and

longitude=@longitude1 and signup_name != @signup;

end

if (@music1 is not null and len(@music1) > 0)

begin

select * from [profile] where music like '%@music%'

and place = @place1 and latitude=@latitude1 and

longitude=@longitude1 and signup_name != @signup;

end

if(@tv_shows1 is not null and len(@tv_shows1) > 0)

begin

select * from [profile] where tv_shows like

'%@tv_shows1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@movies1 is not null and len(@movies1) > 0)

begin

select * from [profile] where movies like '%@movies1%'

and place = @place1 and latitude=@latitude1 and

longitude=@longitude1 and signup_name != @signup;

end

if (@cuisines1 is not null and len(@cuisines1) > 0)

begin

select * from [profile] where cuisines like

'%@cuisines1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@intrested_in1 is not null and len(@intrested_in1)

> 0)

begin

select * from [profile] where intrested_in =

@intrested_in1 and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@education1 is not null and len(@education1) > 0)

begin

select * from [profile] where education

like'%@education1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@college_university1 is not null and

len(@college_university1) > 0)

begin

select * from [profile] where institution like

'%@college_university1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@occupation1 is not null and len(@occupation1) >

0)

begin

select * from [profile] where occupation like

'%@occupation1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@industry1 is not null and len(@industry1) > 0)

begin

select * from [profile] where industry like

'%@industry1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@job_desc1 is not null and len(@job_desc1) > 0)

begin

select * from [profile] where job_desc like

'%@job_desc1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

if (@career_intrest1 is not null and

len(@career_intrest1) > 0)

begin

select * from [profile] where career_intrest like

'%@career_intrest1%' and place = @place1 and

latitude=@latitude1 and longitude=@longitude1 and

signup_name != @signup;

end

GO