Selecting values from comma separated string

Hi all,

I want to write a function that takes as param a comma separated values
string and perform a select matching these values.

Here is the string '1,3,7,8'

And I wan to perform a : SELECT * FROM my_table WHERE id IN (1, 3, 7, 8);

Does anyone have a clue ?

Thanks

Nacef