Can anyone tell me what is the correct form for the following query SELECT ... WHERE fld1='John's car' How does one treat the internal single quote within such a query? I imagine it has to be somehow escaped but cannot find a reference anywhere. Many thanks, Peter McConachie