|
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 item Any assistance would be greatly appreciated.
(comments are locked)
|
|
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),'') Thank you very much
Sep 28 '11 at 08:25 AM
siera_gld
(comments are locked)
|

