Table of Contents

Class Concat

Namespace
YndigoBlue.Velocity.Functions
Assembly
YndigoBlue.Velocity.dll

Represents the CONCAT string function that combines multiple strings into one.

public class Concat : Function, ICheckItem, IDefaultItem, IFilterItem, IElement
Inheritance
Concat
Implements

Remarks

The CONCAT function joins multiple string values into a single string. Null values are typically treated as empty strings in concatenation. This function is useful for building full names, addresses, or composite identifiers from multiple columns.

Examples

Concatenate the first name, a space, and the last name into a full name:

var schema = manager.LoadSchema("crm");
var customers = schema["customers"];

var query = new Query()
    .Select([ customers["id"], new Expression("full_name", new Concat(customers["first_name"], " ", customers["last_name"])) ])
    .From(customers);

var results = manager.Retrieve(query);

Constructors

Concat(IEnumerable<IElement>)

Initializes a new instance of CONCAT with multiple elements to concatenate.

Concat(List<Column>)
Concat(string, Column)
Concat(Column, string)
Concat(Column, string, Column)
Concat(Column, Column)
Concat(Column, Column, Column)