Question: You have a table and the source data looks like this: Given that: The first 6 bytes represent the PO Box number of the vendor

You have a table and the source data looks like this:
Given that:
The first 6 bytes represent the PO Box number of the vendor
The next 5 bytes represent the Vendor Number
Both fields (PO Box Number, Vendor Number) have been defined with an ASCII data encoding
How would you create one field comprised of the PO Box number and the vendor number? The created field will contain 11 numbers. Select all that apply.
a. Without deleting either field, highlight the first 11 numbers in the table layout.
b. Create a computed field concatenating the two fields using the + symbol.
c. Create a computed field concatenating the two fields using the CONCAT() function.
d. Delete both fields because you cannot define data twice and then highlight the first 11 numbers in the table layout.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!