I need to convert the address field data in to 3 parts(ADDR1, ADDR2, ADDR3), currently the address field is split into 2 parts.
(ADDR1 and ADDR2)

code:

(select T1.ROW_ID,T1.CU ST_STAT_CD,
replace(replace (replace(replac e(T1.NAME,char( 10),''),char(13 ),''), char(9),''),cha r(44), '') as NAME,T1.LOC,
case when (CHARINDEX(CHAR (13)+CHAR(10), T2.ADDR) -1) < 0
then REPLACE(SUBSTRI NG(ADDR,...