In Keyword And Multi Value In Single Parameter

Hello

I created a table adapter with the following query

select * from building where buildingname in (@param1)

I used the query builder to the test the query and it works ok if I pass a single value

ex: name: @param1     value: Building1

but when I use the value: Building1, Building2 then it doesn't return anything

If i do a direct sql: select * from building where buildingname in ('Buiding1','Buiding2') returns many rows.

Now I have a class that has the following function<System.ComponentModel.DataObjectMethodAttribute(ComponentModel.DataObjectMethodType.Select, False)> _

Public Function getBuilding(ByVal building As String) As myDataSet.buildingDataTableReturn adapter.getBuilding(building)

End Function

When I call this function I try to pass the building value sorta like

dim building as string = 'Building1,Building2'

and it doesn't work.  I tried a whole bunch of variations. 

How are you supposed to format the parameter string?

Thanks

Peter