>>Hi,
>>
>>I think there was a discussion/question on how to compare two long strings. I simply missed it.
>>
>>I have 4 functions (in my VFP application) which seem to have a similar SQL Select. I need to compare them (two at a time) and refactor the application so that only one function would have this SQL Select. I prefer not to install any software on this PC. This is Windows 7 and I am afraid that a new software will break something (call me paranoid)
>>
>>Please let me know if this is possible with a VFP function.
>
>The right software for this job is Beyond Compare. I can't imagine working without it.
>
>That said, try running the commands through NORMALIZE() and then simply comparing them with ==. That'll tell you if they're identical other than abbreviations.
>
>What that won't do is deal with the possibility that you listed fields or conditions in different orders or used different ways of expressing the same thing.
>
>Tamar
Thank you. I found Beyond Compare (by Googling it). I will see how much "damage" it may do to my PC if I download and install it.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham