Here's a small homework assignment to help you continue to improve your ability to write scalar UDFs. You can find the answers online in the UserDefinedFunctionsPartIIHomework.sql script file at http://www.tsqlsolutions.com, InstantDoc ID 26549. Applying the tools and tips I gave you in this column, create and populate your sample table as
Listing A shows. First, write a function to handle the odd character strings that you use to store the separate d...