I need an apostrophe in part of a SQL statement I'm constructing from code. The code works if I take it out but I get a ByRef error if I put it in. I've tried looking at previous posts but still can't sort it out. Please help
can you post your SQL string please.
Normally you have to enclose apostrophes in double quotes and concatenate the strings on either side of it with & operators
Thanks very much one and all:
I had tried "'" i.e. " ' " but not
"''" i.e. " ' ' "! - this was my first proper foray into SQL and it works now, so thank you.... I'm not sure how I'd manage without the forum to search/ post to