Adding an extra ' to a SQL query

Ignition
1

I have a calendar that picks a date, input for entering in shift begin and end. All of this gets concatenated to a where string. Works fine except I need to add an extra ` around the date/time sof the query doesn’t do arithmetic on the date. I’m having trouble trying to accomplish this.

 'Where logdatetime between '+ {Root Container.Table.Begin1stShift} + ' and '+ {Root Container.Table.End1stShift}
2

I’ve found that if I use double quotes all the time except when I need an embedded quote, it works fine. Like this:

“Where logdatetime between '” + {Root Container.Table.Begin1stShift} + “’ and '”+ {Root Container.Table.End1stShift} + “’”

I think you can use the escape character too.