>cSQLPassThrough = [SELECT * FROM MyTable ] + ;
> [WHERE MyField = "Adam's Apple" ]
>
>Try doing that one with quotes. It gets ugly.

Well, since you ask! :) (Assuming the backend is SQLServer)

cSQLPassThrough = "SELECT * FROM MyTable " + ;
    "WHERE MyField = 'Adam''s Apple'"

I agree that using brackets is a better idea, though! :)