This will probably work as a quick & dirty solution
IF @ListOfFields NOT LIKE '%"' + @MyField + '"%'
but if you actually want to "process" the @ListOfFields then you need a splitter function as Tara described (or, I think, SQL 2016 which has that as a native function)