Is there a way to do this horizontally instead of vertically ?

165476~2345678~123456

Column1 column2 column3

165476 2345678 123456

I have a field in an SQL table that I need to parse out horizontally into multiple columns depending on the number

of deliminated characters in the string.