j2cagle (5/9/2013)
It's just a string variable in VB. There is no " or ' choice. It works fine when you just pass in "ABC", but when a space is introduced...that's when things crash and burn...
Sorry, I'm not a VB programmer, I am a SQL Server DBA/Developer.
In SSMS you would execute the stored proc like this:
exec dbo.MyProc 'ABC DEF GH'