Recent content by iwantoh

We do have badly typed in part numbers like Q A1122 B_ and PB765 A#. I don't think this would work with general rule, we have decided to do manual clean up on badly typed in parts. Then use the query to extract the disired part numbers. This would save us a lot of time.

Sorry, there I did not give a good example, hear are the good ones: QA3122GA QR3122FG TB 765NA (the blank space after TB is required) As general rules, the three digits can be identified from the forth position or before the last two characters. Can this be done in query instead of codes?

The three digit numbers represent part types and can be found in different part numbers e.g. QA3122GA, QR34122FG, TB765NA etc. The desired results would be any part maches the three digit numbers or the closed possible result that can be found. All parts have a fix length of 8 characters.

Here are examples of the two tables and unformated part number in the PART table Trancation table: Transaction Code Part Number AN10002 QA1122BA AN10002 PB765AN Part Table: Part Number Q A1122 B_ PB765 A# As you can see part numbers in part table are not...

I have two tables, The first table is a transaction table and the other one is a list of part numbers (thousand of parts numbers in the table). I need to query these two tables by connecting them with part number fields. My problem is the part numbers in the other table is not correctly...

I have two tables, one is transaction table and the other one is a list of part number. I need to run a query on these table by connecting the part number field on both tables. Since part numbers in the other table are not well formated, the only way to query the two table on part number but...