Hi,
I have a parameter queery which asks for "Name " .
I want to
Enter a few characters and find similiar full names to it which are in the field "Names".
For example: If I type
chr
it should find out "christine"
Pleae help
Best regards
Nadeem
ndmalam
0
Newbie Poster
Recommended Answers
Jump to PostHi,
What brale said is true if you are using SQL Server, but in case of access the wild char. is * so it will be:
where name like "chr*"
All 2 Replies
brale
0
Newbie Poster
You can use like expretion in criteria field.
For example you can use:
LIKE N"ch%"
% character can exange any array of characters.
With this condition you will get all records where this field start with "ch".
kb.net
0
Junior Poster
Hi,
What brale said is true if you are using SQL Server, but in case of access the wild char. is * so it will be:
where name like "chr*"
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.