String Operators and Examples

Character

Operator

Explanation

Example

Queries For

$

Starts with

Starts with the given string.

$Contrast

Contrast

A search can "start with" no operator; however, the $ string operator can be used to include spaces and special characters in the search string.

 

Starts with the given string including a space.

$ Contrast

"Contrast"

Quotation marks used to show the preceding space.

See the / string operator for comparison.

 

Starts with the given string including the / character.

$/Contrast

Begins with /Contrast

/

Contains

Contains a given string.

/Contrast

Procedure descriptions with the word Contrast

When the search string contains a character that is also a string operator, the first occurrence of any of the string operators becomes an escape for the next character and the second character is included in the search string.

 

Contains the given string including the - character or the / character.

/-Contrast

//Contrast

Contains -Contrast

Contains /Contrast

\

Does not contain

Does not contain the given string.

\Contrast

Any string that does not contain Contrast

\=

Does not contain

Does not contain the given string including the = character.

\=Contrast

\==Contrast

Any string that does not contain =Contrast

Any string that does not contain ==Contrast

!

Does not start with

Does not start with the given string.

!Contrast

Does not start with Contrast

=

Equals

Equals the given string.

=Contrast

Equals Contrast

Related Topics

Advanced Query by Example Overview