• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Query Expressions

As when you learned to filter your database (in Chapter 15), there are options for filtering your queries so that no unwanted data appears in your results. Table 17.1 lists expressions to use when creating your query.

Table 17.1. Query Expressions
ExpressionThe Way You Type ItHow It Works
Equals=The field must equal the indicated value
Does not equal<>The field does not equal the indicated value
Is greater than>The field is greater than the indicated value
Is greater than or equal to>=The field is greater than or equal to the indicated value
Is less than<The field is less than the indicated value
Is less than or equal to<=The field is less than or equal to the indicated value
Is one ofIs (x,y,z)The field is one of a list of items shown in parentheses, separated by commas
Is not one ofNot in (x,y,z)The field is not one of a list of items shown in parentheses, separated by commas
Is betweenBetween x and yThe field is between two values, separated by commas
Is not betweenNot between x and yThe field is not between two values, separated by commas
Begins withLike 'x%'The field begins with the value (shown as x)
Does not begin withNot like 'x%'The field does not begin with the value (shown as x)
Ends withLike '%x'The field ends with the value (shown as x)
Does not end withNot like '%x'The field does not end with the value (shown as x)
ContainsLike '%x%'The field contains the value (shown as x)
Does not containNot like '%x%'The field does not contain the value (shown as x)
LikeLike 'x'The field is like the value (shown as x), using wildcard characters * and ?
Not likeNot like 'x'The field is not like the value (shown as x), using wildcards characters * and ?
Is NullIs NullThe field is empty
Is not NullIs not NullThe field is not empty



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint