I have a report stored procedure using a multi value input for paramaters
the input uses a comma split string as the paramater.
i need to remove any spaces entered by the user so that the paramater string will evaluate the records it needs to pull.
Below is the piece of code in my stored procedure that reads the users items
now if the end user places a value of 12345,98765 - it works because it has no space between the comma and the second item. But 12345, 98765 does not work. The report renders but does not evaluate the second itemAny assistance would be greatly appreciated.
asked Sep 27, 2011 at 04:10 PM in Default
Maybe I am missing something, but could you not simply search the string before it is passed into your logic?i.e: REPLACE(@ITEM,SPACE(1),'')
answered Sep 28, 2011 at 05:29 AM