CODEWITHSUNDEEP
stringapostrophe
Vegeta1
Vegeta1

Reputation: 11

Bigquery: Referencing column values with apostrophe in where clause

My where clause is (where Cut_Time_LOS_by_Outgate = "Order's past cutoff") ---> throwing an error because of apostrophe after Order. The open and closed double quotes are part of the whole string.

(where Cut_Time_LOS_by_Outgate = '"Order's past cutoff"')

Upvotes: 0

Views: 72

Answers (0)

Related Questions