Tag: postal-code

Select to pull Zip code based both foreign and domestic

I need to write a T-SQL procedure where the parameter is zip code. We’ve got the following parameter declared. Sample data in table: postal_codes NULL 46383 074523632 B4H34 113601419 ZH/8600 A1G 9Z9 WN73R Wd3 3he 89136 etc. We’ve got a variety of addresses some having no postal code for certain fo…