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...