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.