(Solved) : Build List Contacts New Jersey Manufacturers Follows Contactfirstname Contactlastname Phon Q43982546 . . .
Build a list of contacts for New Jersey manufacturers as follows:ContactFirstName, ContactLastName, Phone. HINT: To do this you willneed to split the contact name into two columns. You will need toembed string functions within string functions. It may be helpfulto use Substring and Charindex. For last name, you can use aliteral of 20 characters as the length to ensure you pick up allthe characters to the end of the field.)
Customer Product Manufacturer CustomerID Manufacturer D 0 FirstName Sale SaleID SaleDate Customer D Tax Shipping Saleltem SaleID ProductID Item Size Quantity LastName StreetAddress ProductiD ProductName ManufacturerID Composition ListPrice Gender Category ManufacturerName Address1 Address2 City City Sale Price State State PostalCode Country Phone PostalCode Phone Color Fax Description Contact Employee Employeeld on FirstName LastName Address City State ZIP SalaryEmployee Employeeld Salary URL Phone ManageriD SSN EmailAddress WageEmployee Employeeld Wage MaxHours HireDate Show transcribed image text Customer Product Manufacturer CustomerID Manufacturer D 0 FirstName Sale SaleID SaleDate Customer D Tax Shipping Saleltem SaleID ProductID Item Size Quantity LastName StreetAddress ProductiD ProductName ManufacturerID Composition ListPrice Gender Category ManufacturerName Address1 Address2 City City Sale Price State State PostalCode Country Phone PostalCode Phone Color Fax Description Contact Employee Employeeld on FirstName LastName Address City State ZIP SalaryEmployee Employeeld Salary URL Phone ManageriD SSN EmailAddress WageEmployee Employeeld Wage MaxHours HireDate
Expert Answer
Answer to Build a list of contacts for New Jersey manufacturers as follows: ContactFirstName, ContactLastName, Phone. HINT: To do …
OR