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.