IsLike

Table of Contents



Returns true (1) if the text matches the pattern. The pattern uses the same wildcards as Like: % matches any number of characters and _ matches a single character.

Boolean IsLike(String text, String pattern)

Boolean results

Boolean functions return 1 for true and 0 for false. In a WHERE clause compare the result to 1 (or true), for example: WHERE IsLike(Text, 'Cat%') = 1


round-pushpin Selects words that start with 'Ca'.
SELECT Text FROM WordList:Word WHERE IsLike(Text, 'Ca%') = 1

round-pushpin Evaluates a constant.
SELECT IsLike('Hello World', '%o w%') as Matches FROM Single




SQL :: IsNotLike
Returns true (1) if the text does not match the pattern. See [[Like]] for the wildcards.
SQL :: IsNull
Returns true (1) if the given value is null, otherwise false (0). This is how to test for missing fields and for the unmatched side of an outer join.
SQL :: IsNumeric
Returns true (1) if the given value is a number: digits with an optional leading sign and an optional decimal point. Null and empty values return 0.
SQL :: IsString
Returns true (1) if the given value cannot be converted to a number.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: LastIndexOf
Returns the zero-based position of the last occurrence of textToFind in textToSearch. Returns -1 when it is not found.
SQL :: Left
Returns the given number of characters from the start of the value.
SQL :: Length
Returns the number of characters in the given value.
SQL :: Like
Allows basic pattern matching in a where clause.
SQL :: Not
The NOT keyword negates LIKE and BETWEEN.