SQL Server——将字段分割为4列

I have a function that split an address line into 4 columns when it encounters a carriage return. It is a multi statement table valued function. How can I use it to split the address line field from the address table? I cannot use joins because it uses the table fields as paramaters. Any clue?I have a function that split an address line in