>I have a Contacts table, a Categories table, and a ContactCategories table:
>
>

>CREATE TABLE Contacts
>	(RecordId		INT	IDENTITY	NOT NULL,		-- PK of the row
>	 ContactName	VARCHAR(150)	NULL,
>	 Title			VARCHAR(30)		NULL,
>	 CompanyName	VARCHAR(50)		NULL,		
>	 BirthDate		DATETIME		NULL,
>	 IsGoogle		TINYINT			NULL,
>	 IsConstant		TINYINT			NULL,
>	 IsSkype		TINYINT			NULL,
>	 PictureName	VARCHAR(150)	NULL,
>	 GoogleId		VARCHAR(250)	NULL,
>	 SkypeId		VARCHAR(100)	NULL,
>	 Notes			TEXT)
>
>
>CREATE TABLE ContactCategories
>	(RecordId		INT	IDENTITY	NOT NULL,		-- PK of the row
>	 ContactId		INT				NOT NULL,		-- FK into Contacts.RecordId
>	 CategoryId		INT				NOT NULL)		-- FK into Caategories.RecordId
>
>CREATE TABLE Categories
>	(RecordId		INT	IDENTITY	NOT NULL,		-- PK of the row
>	 Caption		VARCHAR(50)		NOT NULL)		-- Caption of the Categorie
>
>

>
>
>For a report I'm pulling the contacts that match certain criteria. I want to add in Category. Here's what I have so far, but I'm unsure how
>to code this to add the Category.
>
>

>CREATE PROCEDURE lb_GetContactReportData2
>	@ContactName	VARCHAR(150) = NULL,
>	@Title			VARCHAR(30) = NULL,
>	@CompanyName	VARCHAR(50) = NULL,
>	@Category		VARCHAR(30) = NULL
>
>AS
>
>	SELECT	c.ContactName, c.Title, c.CompanyName, c.BirthDate,
>			cat.Caption AS Category,
>			a.Street1, a.Street2, a.City, a.State, a.ZipCode,
>			e.EmailAddr,
>			p.PhoneNum,
>			w.WebSiteURL
>			FROM Contacts c
>			FULL JOIN ContactCategories cc ON cc.ContactId = c.RecordId
>			FULL JOIN Categories cat ON cat.RecordId = cc.CategoryId
>			FULL JOIN Addresses a ON a.ContactId = c.RecordId AND a.IsPrimary = 1
>			FULL JOIN Phones p ON p.ContactId = c.RecordId AND p.IsPrimary = 1
>			FULL JOIN Emails e ON e.ContactId = c.RecordId AND e.IsPrimary = 1
>			FULL JOIN WebSites w ON w.ContactId = c.RecordId AND w.IsPrimary = 1
>			WHERE c.ContactName LIKE '%' + @ContactName + '%' OR
>				  c.Title LIKE '%' + @Title + '%' OR
>				  c.CompanyName LIKE '%' + @CompanyName + '%'
>			ORDER BY ContactName, Title, CompanyName
>
>

1. Why do you need FULL JOIN and not LEFT JOIN?

2. I would assume something like OR (@Cat IS NULL or Cat.Caption LIKE '%' + @Cat + '%') -- if category selection is optional (looks like all your other criteria are optional).