[SQL Server Data Warehousing]Replace function ineffective with the string more than 90 chars

Hi,

I am working on T-SQL stored procedure. In my code i use REPLACE function. It works fine until i pass the string of length more than 90 characters.

where geography in (''' + REPLACE(@Geography,',',''',''') + '''' + ')'

The geography value is passed from SSRS report, where i send the parameter with the JOIN function using comma seperator. In this stored procedure i frame the multivalued parameter using the replace function. I have tried changing the parameter resolution to nvarchar(500) no changes notified

The problem is that it is working ABSOLUTELY fine until i pass  @Geography with more than 90 characters.

---

Bunch of thanks ~ Deva ~ 

.

social.technet.microsoft.com/Forums