Try this:
DECLARE @tbl TABLE (myText NVARCHAR(30))
INSERT INTO @tbl(myText)
VALUES('Friday,May,05,2013')
;WITH cte AS
(
SELECT LEFT(myText, CHARINDEX(',', myText)-1) AS Word, RIGHT(myText, LEN(myText) - CHARINDEX(',', myText)) AS Remainder
FROM @tbl
WHERE CHARINDEX(',', myText)>0
UNION ALL
SELECT LEFT(Remainder, CHARINDEX(',', Remainder)-1) AS Word, RIGHT(Remainder, LEN(Remainder) - CHARINDEX(',', Remainder)) AS Remainder
FROM cte
WHERE CHARINDEX(',', Remainder)>0
UNION ALL
SELECT Remainder AS Word, NULL AS Remainder
FROM cte
WHERE CHARINDEX(',', Remainder)=0
)
SELECT *
FROM cte
WHERE Word = 'May'
More about
Common Table Expressions[
^].