SP getting a list as a parameter

[BryanHood]

I would like to pass into a SP a string containing a list of items, and then use that list in a Where clause.Example:exec sp_FindFromList '1, 2, 3, 4, 5'

Create Proc dbo.FindFromList    @paramList as VarChar(100)ASSelect  *From   myTableWhere  column1 IN (@paramList)GO

I would like to parse out the list into individual items.Thank you,Bryan

[aspnetguy]

try thishttp://www.devx.com/tips/Tip/20009

[BryanHood]

That was it!Thanks ASPNetGuy! (Or would that make you SQLandASPNetGuy?)

try thishttp://www.devx.com/tips/Tip/20009

<{POST_SNAPBACK}>

[aspnetguy]

That was it!Thanks ASPNetGuy!  (Or would that make you SQLandASPNetGuy?)

<{POST_SNAPBACK}>

Hey no problem...I think Your Majesty or Your Excellence will suffice