Create a function called fn_VendorAddress that gets a VendorName passed in, and returns a Varchar out. [Vendors table]

The function should return the full address of the vendor as a return parameter. The full address should be VendorAddress1, VendorAddress2 (if it has a value), VendorCity, VendorState, VendorZipCode:

So PO Box 96621, Washington DC, 20090 for VendorName: National Information Data CTR.

Create a script that tests your function with Vendors that have a value for VendorAddress2 and Vendor's that don't have a value for VendorAddress2

Answer rating: 100% (QA)

Heres a sample SQL function named fnVendorAddress that retrieves the full address of a vendor based ... View the full answer