KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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