Tech Tip: Case sensitive search option for Position command in 4D v11 SQL

PRODUCT: 4D Developer | VERSION: 11.1 | PLATFORM: Mac & Win

Published On: July 8, 2008

In 4D v11 SQL, the Position command can be passed the * parameter to specify diacritic-sensitive searching. This means that the case and any diacritic (accent) marks will be taken into account when searching for the specified string.

Here is an example showing the results of executing the same Position command on three different strings:

C_LONGINT($l1;$l2;$l3)

$l1:=Position("e";"This is a test.";*) `$l1 = 12
$l2:=Position("e";"This is a TEST.";*) `$l2 = 0
$l3:=Position("e";"This is a tëst.";*) `$l3 = 0