How to use split function in sql server..

Hi Friends, I have one Table like ShownBelow... Domain Name    Min Years    MaxYears .com                2               10 .net                4               12 .co                 1               12 .buz                1               13 But Am passing parameter to stored procedure like this way .com,.net,.co Now i need to split this value and check with database and again i need to return dataset like above table Domain Name    Min Years    MaxYears .com                2               10 .net                4               12 .co                 1               13 .buz                1               13