DECLARE @Parameter1 VARCHAR(MAX) = Null
In the where clause use the format below:
WHERE (( @Parameter1 IS NULL) OR ([Field1] = @Parameter1))
In the where clause use the format below:
WHERE (( @Parameter1 IS NULL) OR ([Field1] = @Parameter1))