I have working with VFP all my career, and never noticed the Normalize() function. I could have saved myself hours of work if I had. Thank you.

>Take a look at Normalize()
>
>[Update]For some reason the link does not work if clicked directly, you need to open it on a new window (shift-click)[/Update]
>
>>Hi all,
>>
>>Don't even know what to search for - I thing I remember seeing a function that does this. Basically, I want to know what VFP is going to do with my code when I set a filter e.g.
>>
>>SET FILTER TO State = 'NY'
>>
>>when I query FILTER(), it returns STATE="NY"
>>
>>i.e. it strips out the spaces and changes my single quotes to double.
>>
>>Why do I need this? In one form I want to only fire the SET FILTER statement if the user has changed something. But my worked up filter string is always going to be different than what VFP returns via FILTER(). Especially something like:
>>
>>SET FILTER TO State = "NY" OR State = "PA"
>>
>>becomes this with FILTER()
>>
>>STATE="NY".OR.STATE="PA"
>>
>>I am sure I saw a function for this at one point.
>>
>>Albert