Hi Neil,
I didn't ask to post the whole book, just the code that proves your point.
>As the document is copyright by Tamar, can you clear it with him first.
>
>Here is the link to the document
http://www.hentzenwerke.com/catalog/tamingvfpsql.htm>I would recommend this to everyone and it is worth every cent.
>
>>>I refer you to page 130 of Tamar's Taming SQL and the example of "Smith = S" and the effect of SET EXACT OFF, with SET EXACT OFF the results may not be what you expect.
>>
>>I don't have a book. Can you provide code that shows it?
>>
>><snip>
--sb--