A common requirement is to get the post code (zip code for the US readers) from an address. When the address fields are concatenated into a single row of data the post code, while being ...
Use Case: Another useful design pattern to have at your fingertips is the ability to parse out a single row of a value(s) into multiple rows BUT—and this is the caveat that makes it all ...