Converting a comma separated field into an array

Hello,

I had a column that has comma separated values such as 154,165,178. How do I convert this to an array and be able to execute array functions such as ARRAY_SIZE and ARRAY_SLICE on the column ?