Comparing text

[gasbored]

Lets say I have the following two text fields

Field1= "Today is Monday"
Field1 = "Today is Monday and it is sunny"

If Field1<>Field2, I want to set Field3 = " and it is sunny"

In other words I want to record the 'difference' between the two strings. I Venn Diagram language, I want to get Field1/Field2

Is there a way to do this in SQL ?

 

[plog]

Yes, you use the Instr function (http://www.techonthenet.com/access/functions/string/instr.php). It will tell you if one string is a substring of another and return 0 if it is not.

If you find that one is a substring of another, you simply determine the length of the substring and use Mid (http://www.techonthenet.com/access/functions/string/mid.php) to retrieve the remainder of the superstring when starting where the substring ended.

 

[gasbored]

Thanks, that sounds like it