Google BigQuery Replace function for string type
<p>I am trying to replace certain customer names in my data.
I was able to do SQL using Google BigQuery language to transform one part of the string another via the replace function for one particular string. </p>

<pre><code>Replace(CustomerName, 'ABC', 'XYZ')
</code></pre>

<p>However, I have a couple more that I would need to use the replace function such that</p>

<pre><code>Replace(CustomerName, 'PLO', 'Rustic')
Replace(CustomerName, 'Kix', 'BowWow')
</code></pre>

<p>and so on.</p>

<p>I've tried doing </p>

<p><code>Replace(CustomerName, 'ABC', 'XYZ') OR Replace(CustomerName, 'PLO', 'Rustic') OR Replace(CustomerName, 'Kix', 'BowWow')</code></p>

<p>but that got me an error message.</p>

<p>I've also tried </p>

<p><code>Replace(CustomerName, 'ABC', 'XYZ') AND Replace(CustomerName, 'PLO', 'Rustic') AND Replace(CustomerName, 'Kix', 'BowWow')</code> </p>

<p>but that also got me an error message.</p>

<p>I am able to just use "case when statement" and then hardcode each one, but I'm wondering if there is a better/faster way to just use replace statement instead.</p>

<p>Thanks for your help.</p>