How do I parse Address into Street Number, Street Name, Type, Unit Number?

1 vote

0 answers

1749 views

sql-server sql-server-2016 functions parse address

                          How do I parse Address into Street Number, Name, Type, Unit Number? Is there a function which will conduct this?

    2280 MEYERS AVE                                            
    ALDERGROVE AVE & S VINEWOOD ST                             
    SIMPSON WAY & N HALE AVE        
    412 E WASHINGTON AVE #3                                                               
    AVOCADO AVE & LEMON ST                                     
    572 N TULIP ST                                             
    1030 HAWAII PL                                             
    500 N MIDWAY DR A-E, ADMIN                    

             
                        

Asked by user173948

Mar 18, 2019, 06:31 PM

How do I parse Address into Street Number, Street Name, Type, Unit Number?

Related Questions