Starts with relational operator

In a search screen, the starts with (#) relational operator is the default query type, unless you use a wildcard character. If the value you enter contains wildcard characters, the like relational operator is assumed. To use the starts with operator in conjunction with wildcard characters, enter the starts with (#) operator as the first character in your query.

In the query window, everything is interpreted literally as you type it in.

Related topics

Relational operators
Wildcard characters
Retrieving records by using the record list method
Retrieving records using the Query window method
Use the equal to relational operator
Use the greater than relational operator
Use the like relational operator
Use the less than relational operator
Use the starts with relational operator
Perform IR Expert queries