All Forums Database
Kbos 20 posts Joined 04/13
11 Mar 2016
Find a way to standardize addresses

Hi Guys,
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:
Address #1
Street 111 Williams Hall
Address #2
St 111 Williams Hall
Address #3
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.

 

You must sign in to leave a comment.