CREATE PROCEDURE sp_SearchName
@v2 char

AS
select name, sex from inf_tbl where name like @v2%

If the user input 'M' , the procedure can show all names start from 'Mxxxx',
but I can't show this .
What's wrong with this procedure ?
I think there is something wrong with operator 'like'.