tt |
GoldMine Apprentice |
|
|
Joined: 18 Jan 2007 |
Posts: 23 |
|
|
|
|
|
|
|
|
I'm trying to figure out if if I can accomplish the following in a sql query for a "Replace History" function.
I have a current sql statement that reads as follows and which works perfectly:
CONTHIST.RECTYPE = 'L' AND CONTHIST.ACTVCODE ='FOR' AND CONTHIST.REF LIKE 'BML00%' AND ( CONTACT1.CONTACT ='' OR CONTACT1.CONTACT IS NULL)
I am trying to add an additional condition to the above statement that would select history records where the reference field of the activity does not contain the record's company name in it. I have tried appending the 2 following statements to the above statement but neither of them work.
AND CONTHIST.REF NOT LIKE %CONTACT1.COMPANY%
AND CONTHIST.REF NOT LIKE '%CONTACT1.COMPANY%' |
|