use MEDICARE
go


CREATE PROCEDURE dbo.sp_Med_Memberlist--''
@Search as varchar(100)

as

Select top 1000 MemberNumber, ISNULL(LastName,'') Lastname, ISNULL(Firstname,'') Firstname,ISNULL(MiddleName,'') MiddleName,
		ISNULL(HouseStreet,'') HouseStreet,ISNULL(Barangay,'') Barangay
		,ISNULL(ZipCode,'') Zipcode, ISNULL(EmployerNum,'') EmployerNum, 
		ISNULL(CONVERT(varchar,Birthdate,101),'') Birthdate,ISNULL(Sex,'') Sex

from MEDICARE..tbMedMember
Where MemberNumber like @Search + '%'
	OR (ISNULL(LastName,'') + ', ' + ISNULL(Firstname,'') + ' ' + ISNULL(MiddleName,'')) like @Search + '%'
	OR EmployerNum like @Search + '%'
	OR BirthDate like @Search + '%'