Determines how the SET EXACT command compares strings
SET PCEXACT ON | OFF | (<expL>)
DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, EDITFIELD(), FILETYPE(), INDEXEXT(), LEFT(), LPAD(), LTRIM(), RIGHT(), RPAD(), RTRIM(), SOUNDEX(), SUBSTR(), TRIM(), SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET EXACT, SET FILECASE, SET FILETYPE, SET INDEXEXT, SET MEMOEXT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE
The SET PCEXACT command affects the way that the SET EXACT command performs string comparisons. If SET PCEXACT is ON, and SET EXACT is ON, the strings compared need not be an exact match in length. PCEXACT allows for the presence of spaces on the right side of strings. If PCEXACT is ON, and SET EXACT is OFF, PCEXACT will have no affect on string comparisons. If SET PCEXACT is OFF, and SET EXACT is ON, strings are compared for exact length and content. If SET PCEXACT is OFF, and SET EXACT is OFF, strings are compared up to the length of the shortest string. By default, PCEXACT is OFF.
set exact on ? "abc" = "abc " .F. set pcexact on ? "abc" = "abc " .T. set pcexact off set exact off ? "abc" = "abc " .F.
Recital Server, Recital