double pipe operator - Nexus Veritas

# double pipe operator ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course#5.2 Google Analytics - 5 Analyze - Module 2 - Format and Adjust Data Format and Adjust Data|Google Analytics Certificate]] #### Sub-context: [[CONCAT]] >[! Definition] >Concatenate two or more strings in BigQuery using `||` a double pipe between each field ## Examples ```SQL SELECT book_name || ' - ' || edition AS full_book_title FROM library; ``` ## Related ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) +++ Concatenate two or more strings in BigQuery using `||` {{a double pipe}} between each field  +++