String legnth too long???
I have a Stored proc that has a â@cityList varchar(2000) = nullâ as an input parm.
It is querying a table thus:
Declare @SQL varchar(1000)
SELECT @SQL = âSELECT producerID, ProducerName from tblProducers where City IN (â + cityList +â)â
All is well and good if I pass in ââMontgomeryâ, âBirminghamâ, âAtlantaââ. However, if I try to pass in a string with more than 128 characters, it gives me âThe identifier that starts with <LONG STRING CUT OUT> is too long. Maximum length is 128.â
Is there any way to pass in my cityList if it's greater than 128 characters?