473,395 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

How do I create a query for a partial match?

1
I have a Master Table (tbl1) with part numbers (PNs)and a table of PNs where the single character suffix was dropped (tbl2).
I need to create a query where the PN characters in tbl2 match the PN characters in tbl1 and can have an extra character.
I have tried various sequels but continue to either get too many PNs or no PNs.
How do I create a query that will give me basically the entire PN (tbl2) less 1 character?
Dec 22 '14 #1
1 971
Luuk
1,047 Expert 1GB
i did not know the answer too,
but googling for: 'sql like wildcard access'
showed this site:
http://www.techonthenet.com/access/queries/like.php

so, the answer is:
use a '?' with LIKE
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM tbl1 WHERE part_number like 'PN1234?'
should give all PN's that start with 'PN1234' + an extra character
Dec 22 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Christian Staffe | last post by:
Hi, I would like to check for a partial match between an input string and a regular expression using the Regex class in .NET. By partial match, I mean that the input string could not yet be...
2
by: Andrew Chalk | last post by:
I have a customer who wants to SELECT records based on a partial match in a text field. For example, in a list of telephone numbers they want to search for all records that contain the digits '777'...
2
by: mael.iosa | last post by:
Hi, I'm new to this group and fairly new to Access. I have a bunch of data, and after several other queries, I generate the following query which has two fields: Bin, Time 20 3.5 20 3.9 20...
4
by: wecka | last post by:
Hello All, Does any one know how to use the form filter in Access to provide partial match? When you choose to "form filter," all text boxes will convert to combo boxes where you can choose from...
7
by: Jim | last post by:
How do I program visual basic to create a "Find Unmatched Query"? I have two tables: - TodaysImport - YesterdaysImport Both tables have the same 6 fields: - User
3
by: danielleissy | last post by:
Firstly i would like to know the difference between Keyword searching using SQL and partial matching of a search. I have to search for a book by key word in the book title. But allow TWO key words...
16
by: vorlonfear | last post by:
I have been working on this for a while now and I wanted to see if someone could assist me. I have 2 tables each with 5 fields. 4 of the fields are 2 character strings, then the final field is the...
4
by: Pat Rowe | last post by:
Relative Newbie w/ a stumper! Any help is appreciated. Thanks! I have two tables that I have imported to access. I'd like to query between these two tables for records that have a shared last...
4
Fspinelli
by: Fspinelli | last post by:
I don't know any other way to explain this but: I have a query by form (queries my customer table) that by entering a few letters of a company's name in the search field will bring up results in...
1
by: zivronen | last post by:
Hello all. my question is how can i pass from one page with a form feild to a "Create query" in another page. what i am trying to do is make the Table name in the Create page to have the value...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.