I would like to know if there is a way or function in Teradata which allows me to standardize addresses. For instance, I have the following scenarios:
Street 111 Williams Hall
St 111 Williams Hall
Stt 111 Williams Hall
By reviewing the above examples, I just realize that the addresses are the same, so I would need to generate only one address with the following information
Standardize address --> ST 111 Williams Hall
Is there any way to achieve this? If so, Could you please suggest me any idea or manual where I can find this information?
Thanks in advance.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.