Hi,

I use VARCHAR(MAX) for parameters (Not for fields), These parameters are used in the Where clause of the Query.

for example.

CREATE PROCEDURE [Sample]

(

@deliverycenter varchar(500)

)

as

declare

select * from itemdetails i where i.deliverycentercd in (@deliverycenter)

.....

Here instead of using varchar(500) can I use VARCHAR(Max), does it affects the performance.