Flashcards
Query Criteria
Flashcards do conjunto (21)
- 1"China"It includes items that exactly match a value, such as China
- 2Not "Mexico"It includes items that do not match a value, such as Mexico
- 3Like U*It includes items that begin with the specified string, such as U
- 4Not Like U*It includes items that do not begin with the specified string, such as U
- 5Like "*Korea*"It includes items that contain the specified string, such as Korea
- 6Not Like "*Korea*"It includes items that doesn’t have the specified string, such as Korea
- 7Like "*ina"It includes items that end with the specified string, such as "ina"
- 8Not Like "*ina"It includes items that do not end with the specified string, such as "ina"
- 9Is NullIt includes items that contain null (or missing) values
- 10Is Not NullIt includes items that do not contain null values
- 11"" (a pair of quotes)It includes items that contain zero-length strings
- 12Not ""It includes items that do not contain zero-length strings
- 13"" Or Is NullIt includes items that contains null values or zero-length strings
- 14Is Not Null And Not ""it includes items that is not empty or blank
- 15>= "Mexico"it includes items that follow a value, such as Mexico, when sorted in alphabetical order
- 16Like "[A-D]*"it includes items that fall within a specific range, such as A through D
- 17"USA" Or "UK"it includes items that match one of two values, such as USA or UK
- 18In("France", "China", "Germany", "Japan")it includes items that contain one of the values in a list of values
- 19Right([CountryRegion], 1) = "y"it includes items that contain certain characters at a specific position in the field value
- 20Len([CountryRegion]) > 10it includes items that satisfy length requirements
- 21Like "Chi??"It includes items that match a specific pattern
Informações
- Descrição
- A level ICT FlashCards sobre Query Criteria, criado por Leann McLeod em 15-01-2017.
- Criado por
- Leann McLeod
- Visualizações
- 1
- Avaliação