writing sql procedure
Declare the @pname as varchar(x)  where x is the length of the Physician.Name column.  Make the change in both pieces of code.

Declaring the variable as just varchar indicates you only want a single character at most.