select comma seperated field value with range table comparision

Hi ,

Im trying to pull data from a custom table for a particular field in which values are saved in comma separated

as MM,SD,Date,Time. My input(Parameter) will also be in comma separated like Date,FI,PP. In this case as Date is matching with the saved field value that record should be fetched. Is there any way that we can achieve this in the SELECT(SQL) statement. I can process this in a loop, but looking for SQL solution if any.