Member Avatar for ndmalam

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

  • 3 Contributors
  • 2 Replies
  • 85 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by kb.net
Member Avatar for brale

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".

Member Avatar for kb.net

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.