The second problem can be resolved using substring and padindex e.g.:
select substring(RESIDENTIAL,1,patindex('%,%',RESIDENTIAL )-1) AS Area, substring(RESIDENTIAL,patindex('%,%',RESIDENTIAL)+ 1,4)AS PostalCode
Results 1 to 4 of 4
Thread: seperate namesThreaded View
|
|
|