25.158. SET JOKER "c" TO "abcdefgh..."

[<<<] [>>>]

Set a joker character to match certain characters when using the LIKE operator. The joker character "c" can be one of the following characters

*  #  $  @  ?  &  %  !  +  /  |  <  >

The string after the keyword TO should contain all the characters that the joker character should match. To have the character to match only itself to be a normal character say

SET NO JOKER "c"

See also SETWILD, LIKE (details), JOKER


[<<<] [>>>]