database - How to separate data column into multiple columns in SQL? -

database - How to separate data column into multiple columns in SQL? -

i have client list table has more 1500 records. need separate 1 info field called bill has client billing details client name & address, postcode.

table name: customerlist (customer, bill)

bill has next types records

brandon park fruit market shop 44 brandon pk shopping centre mulgrave, vic 3170 commonwealth of australia superior nutrient services po box 329 aus mulgrave, vic 3170 aus

and on ...

any 1 can help me have separate column postcode.

sql database sql-server-2008