How to write Stored Procedure as Full text Search

See more:

SQL-Server-2005

C#

SQL

.NET

, +

hi to all teachers,...
Friends who write in the query mode Full text Search in Sql Server have experience
Who make this Stored Procedure as a normal Full text Search, which contains and .. Is used, into

Advance of the tips I have thanked all friends perfection.

Email : rezaafandi@yahoo.com

Create PROCEDURE Sp_student
@fname varchar(50),
@lname varchar(50),
@tel varchar(50),
@code varchar(50),
@adr varchar(50),
@search_operation varchar(50),
@totalRowCount bigint output
AS
begin
if @search_operation = 'and'  
begin
SELECT f3,f4,f5,f6,f7  FROM tb_student
WHERE(
f5  like  '%' + @fname + '%' and
f4  like  '%'  + @lname + '%' and 
f6   like  '%'  +   @tel  + '%' and
f7   like  '%'  +   @code  + '%' and
f3  like  '%' + @adr +'%' 
)
select  @totalRowCount = @@rowcount
end