escaping special characters and words

[holstermedia]

I'm adding some custom SQL qualifiers

- WHERE (sale_status available calc=1)

this fails as the field name has 'calc' in it which I imagine is a reserved word. If I rename the field saleStatusAvailableCalc it works fine.

But I have many huge ipad databases in the wild and can't update the field name just now....

So I'd like to escape it - but WHERE (\"sale_status available calc\"=1) fails with a syntax error

Is it possible to do a normal escape at this point?

thanks

Steven

[holstermedia]

update:

I duplicated the field so I can use it for testing. The new field gives an error that I haven't seen before. When testing the SQL qualifier it give "example query failed with this error message: -1"

What does that mean?

the field is text and we're using MS4. I've also tried it with the field as number and saleStatusAvailableCalc=1

s