> SCAN > m.TheWord3 = ALLTRIM(LOWER(indicator)) && Symptom > IF m.TheWord3 $ lcTEXT AND ! m.TheWord3 == m.TheWord1 OR ! m.TheWord3 == m.TheWord2 > REPLACE hits WITH indicator.hits + 1 && Gather simple stats > m.sidenote3 = action && Recommendation > SELECT MASTER > REPLACE indicator3 WITH m.sidenote3 > ENDIF > SELECT indicators > ENDSCAN > SCAN > m.TheWord4 = ALLTRIM(LOWER(indicator)) && Symptom > IF m.TheWord4 $ lcTEXT AND ! m.TheWord4 == m.TheWord1 OR ! m.TheWord4 == m.TheWord2 OR ! m.TheWord4 == m.TheWord3 > REPLACE hits WITH indicator.hits + 1 && Gather simple stats > m.sidenote4 = action && Recommendation > SELECT MASTER > REPLACE indicator4 WITH m.sidenote4 > ENDIF > SELECT indicators > ENDSCAN >>
m.TheWord3 $ lcTEXT AND ! (m.TheWord3 == m.TheWord1 OR m.TheWord3 == m.TheWord2)
...
m.TheWord4 $ lcTEXT AND ! (m.TheWord4 == m.TheWord1 OR m.TheWord4 == m.TheWord2 OR m.TheWord4 == m.TheWord3)Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.