>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