25.159. SET WILD "c" TO "abcdefgh..."

[<<<] [>>>]

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

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

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

SET NO WILD "c"

See also SETJOKER, LIKE (details), JOKER


[<<<] [>>>]