Inter-Tel AXXESS - Combining Commands; Table 6-11 SQL Command Examples with Wildcards; Table 6-12 SQL Command Combination Examples; Wildcards

Page 6-59
Programming
INTER-TEL
®
AXXESS
®
MANUAL VERSION 11.0 – May 2008
Wildcards
PROGRAMMING
6
10.36 In the event that you forget which type it is, you will see an error message pointing out
that you have a “Data type mismatch” and you must return to the statement and enter it cor-
rectly.
Wildcards
10.37 Wildcard characters that can be used for filtering are:
• Asterisk (*) means any character or characters are accepted.
• Question mark (?) is used to indicate a match of a single character.
10.38 Because filtering uses statements composed of letters as well as numbers, the equal sign
means that an exact match must be present. Therefore, the expression [username] = “FRED*”
will only return a username that has the letters F, R, E, D and an asterisk; that is, an actual
asterisk as the fifth character of the username. It would not return “FREDDY” or “FRED
SMITH.” To use the wildcard, the SQL statement must tell the search engine to locate some-
thing that does not exactly equal the search string specified in the quotes. To do this, we use
the SQL command “LIKE.”
10.39 The expression [username] LIKE “FRED*” returns usernames of “FRED,”
“FREDDY,” “FRED SMITH” or any other username that starts with the letters F, R, E, D.
10.40 In a like manner, the question mark is used to indicate only a single character space is a
wildcard.
10.41 Here are some additional examples:
Combining Commands
10.42 It is possible to combine search patterns using the Boolean operators we have already
discussed, as shown in the following examples:
Table 6-11: SQL Command Examples with Wildcards
SQL Statement Search Result
[username] = “FRED?” FRED?
[username] LIKE “FRED?” FRED plus any single character
[username] LIKE “FRED*” FRED followed by any or no additional characters
[username] LIKE “FRED??” FRED followed by any two characters
[username] LIKE “FRED?*” FRED plus at least one more character
[username] > “b” Any username except those beginning with the letter A
[username] < “a” Any username that would occur before those beginning
with the letter A, (e.g.
: blanks)
[extension] LIKE “12??” Extensions in the range 1200 through 1299 inclusive
Table 6-12: SQL Command Combination Examples
SQL Statement Search Result
[username] = “FRED” AND [extension] =
“1234”
Only 1234 with a username of FRED
[username] = “FRED” OR [username] =
“WILMA”
Any phone with a username FRED or WILMA
[username] = “FRED” OR [extension] =
“1234”
Extension 1234 as well as any with FRED as
the username