j2cagle (5/10/2013)
I'm just looking for a way, that when passed "ABC DEF GHI", I could handle it in SQL to simply look only at the value up to the first space.If that can't be done, that's fine...I was just doing some investigation...
Don't think it can be done (at least not in any way I'm familiar with - which might not be setting the bar very high).
You're basically sending in the string without the required single quotes. SQL will consume up to the first space without complaining, but once it hits characters after that space it will throw an exception. So you need a fix at the point Procedure is being called.