# Concatenation Operator

> The || concatenation operator in StackQL: join two or more string values into one string.

Source: https://stackql.io/language-spec/functions/string/concatenation

Returns the resultant string from the concatenation, or joining, of two or more string values.  

See also:  
[[` SELECT `]](/language-spec/select) 

* * * 

## Syntax

```sql
SELECT character_expression1 || character_expression2 FROM <multipartIdentifier>;
```

## Arguments

__*character_expression*__  
A literal string or string column.

## Return Value(s)

Returns a string.

* * *

## Examples

### Concatenate two fields together

```sql
SELECT name || ' (' || location || ')' as bucket_location
FROM google.storage.buckets 
WHERE project = 'stackql-demo';
```

For more information, see [https://sqlite.org/lang_expr.html](https://sqlite.org/lang_expr.html)