I have a multi-valued parameter in SSMS where in need to get the individual parameter values into a table. However, the syntax in which SSMS crates the parameter is something like " N'VALUEA',N'VALUEB'... So, SQL sees it as a list of several smaller strings, at least that is what it looks like when I capture it in the profiler. So, using a normal Split function does not work to break it up into a table. I need suggestions on how to accomplish this. Many thanks.