I'm new at this and just can't seem to get it. Any help is appreciated.
I have a table with an address field that is all together
eg: 1600 Market street
123 s Market Rd
12345 Market Blvd
1 W Market Way
I need to break the field into AddrNo, AddrDir, AddrName, AddrSteet.
I've tried patindex and charindex but still can't get it.
Any suggestions?
Thank you.
I have a table with an address field that is all together
eg: 1600 Market street
123 s Market Rd
12345 Market Blvd
1 W Market Way
I need to break the field into AddrNo, AddrDir, AddrName, AddrSteet.
I've tried patindex and charindex but still can't get it.
Any suggestions?
Thank you.