The delimiter is not working.:w00t:

I have the following in my Stored Procedure:

AND State IN (SELECT State FROM dbo.Split_Multi_Value_Parameters (@State, ','))

I perform a DBCC INPUTBUFFER (SPID) and it parses as follows. I have not included all 50 states:

AND State = N'AL',N'AK'

The problem is that the delimiter function does not have it's intended behavior.