Table of Contents

Search

  1. Preface
  2. Introduction to Informatica MDM - Customer 360
  3. Getting Started
  4. Adding Records
  5. Finding Records
  6. Editing Records
  7. Importing Bulk Data
  8. Working with Drafts
  9. Viewing Tasks
  10. Participating in Review Processes
  11. Managing Tasks
  12. Resolving Duplicates
  13. Investigating Data Changes
  14. Investigating Relationships
  15. Creating Customer Profiles on the Customer Portal

Basic Queries

Basic Queries

Basic queries use simple text comparisons to find records that contain the query values. You can use text and the wildcard character (*) to query values.
The wildcard characters are special search symbols that you can use in basic queries to specify a text pattern instead of specific characters. You can use the asterisk (*) wildcard character to increase your chances of finding the records that you want. The wildcard characters are useful when you do not know the exact text or want to search for similar text.
The following table lists example search strings and explains how they function:
Example Query String
Query Behavior
John Smith
Queries for records that contain
John
,
Smith
, or any variations of
John
or
Smith
as a field value.
"John Smith"
Queries for records that contain
John Smith
or any variations of
John Smith
as a field value.
John*
Queries for records that contain a value that starts with
John
. For example,
Johnson
or
Johnny
.
Jo*n
Queries for records that start with
Jo
and end with
n
. For example,
Johansson
or
Jordan
.
*
Returns all the records.
Basic query is not case sensitive in Microsoft SQL Server environments.

0 COMMENTS

We’d like to hear from you!