Help I trying to query from importing data from AS400

[CAM]

Hello,

I have a two part question 1.) I have a table called "Parts#" that has a
particular field called "ItemNumber" now this table field size is 30 and as
a text field. My problem is I am trying to query a particular item number
(i.e. 555A), but I get no result. If I type Like "555A*" I get 555A,
555AF, 555AT, or 555V. I just want to get 555A only. How do I get just
555A? 2.) I am trying to join using the Parts# table using the field
"ItemNumber" to join to another table called "Summary" with a field to join
called "Item", which is a text field and a field size 16. Now "Item" field
has 555A and I have the same problem from question #1 (above) can't get
555A, just 555AF, 555AT, or 555V.I am trying to join the two tables I cannot
get any results. Can someone help me. Thank you n advance.

Cheers

 

[KC-Mass]

I assume that the data from the AS400 has either trailing or leading spaces
padding out the actual Parts#.

Change your reference to "Part#" to "Trim(Part#)". That will remove the
spaces and allow a direct comparison ("=") rather than a "Like"

Regards

Kevin