How to write stored proc. search record using Like quer by initial charecter

Hi frends,
How to write stored proc. search record using Like quer by initial charecter

my stored procc is i want to select S_Name from SCHEMEDETAIL by like query

set

ANSI_NULLS ON QUOTED_IDENTIFIER ON

-- =============================================

-- Author:

-- Create date:

-- Description:

-- =============================================

ALTER

PROCEDURE [dbo].[Get_SchemeRatings]-- Add the parameters for the stored procedure here

@AMC_CODE

varchar(100)

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for procedure here

select sdt.S_NAME ,tsr.Ratingfrom SCHEME_DETAILS sdt left join T_SchemeRating tsr on sdt.SCHEMECODE = tsr.SCHEMECODEwhere convert (varchar(100),sdt.AMC_CODE)=@AMC_CODE

END

PLZ