How to remove apostrophe s in sql in bigquery?

Question

im still learning SQL for Big Query . How do i remove the "apostrophe s" in this word Let's Go** ? I do need to so some cleaning in the list of data for a single column . Thanks

https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#replace `REPLACE("Let's Go", "'s", "s")` — WOUNDEDStevenJones, Jul 06 '22 at 02:04

score 1 · Accepted Answer · answered Jul 06 '22 at 02:03

1

use below

select replace("Let's Go", "'", "")

with output

answered Jul 06 '22 at 02:03

Mikhail Berlyant

165,386
8
154
230

How to remove apostrophe s in sql in bigquery?

1 Answers1