T
ttp
I have (2) different issues related to concatenate. In one instance, I want
to trim the last character of a string and compare it to a field in another
table. And in the other instance, I want to combine two fields so that I can
compare that new field with a field in another table.
1: I have a field with the value 123456S in one table. And a field with
123456 in another table. How do I remove the S from the field in the first
table and then compare it to the field in the second table?
2: I have a table with a field with the following data: GR12345-2. In
another table, there are two fields which create this value: field 1:
GR12345 and field 2: 2. How do I combine field 1 and 2 in the second table
to compare it to the field in the 1st table?
to trim the last character of a string and compare it to a field in another
table. And in the other instance, I want to combine two fields so that I can
compare that new field with a field in another table.
1: I have a field with the value 123456S in one table. And a field with
123456 in another table. How do I remove the S from the field in the first
table and then compare it to the field in the second table?
2: I have a table with a field with the following data: GR12345-2. In
another table, there are two fields which create this value: field 1:
GR12345 and field 2: 2. How do I combine field 1 and 2 in the second table
to compare it to the field in the 1st table?