Combine addresses missing Unit/Suite #

I have a list of addresses which need to be updated in SQL Server. How can I go about adding the Suite # to the addresses which are missing it? Address 1 Burton Hills Blvd, Suite 250 1 Burton Hills Blvd 1 Burton Hills Blvd 1 Burton Hills Blvd 1 Burton Hills Blvd 1 Burton Hills Blvd 1 Ford Pl 1 Ford Pl, Suite 5B 1 Kish Dr 1 Park Center Dr, Suite 11 1 Park Center Dr