Class Substring
- Namespace
- YndigoBlue.Velocity.Functions
- Assembly
- YndigoBlue.Velocity.dll
Represents the SUBSTRING function that extracts a portion of a string.
public class Substring : Function, IElement, ICheckItem, IDefaultItem, IFilterItem- Inheritance
-
Substring
- Implements
Remarks
The SUBSTRING function returns a substring starting at a specified position with a specified length. Position indexing varies by database (0-based or 1-based). This function is useful for parsing fixed-width fields, extracting codes, or truncating text.
Constructors
- Substring(Column, int, int)
Initializes a new instance of SUBSTRING with literal start position and length.
- Substring(Column, int, Column)
Initializes a new instance of SUBSTRING with literal start position and column-based length.
- Substring(Column, Column, int)
Initializes a new instance of SUBSTRING with column-based start position and literal length.
- Substring(Column, Column, Column)
Initializes a new instance of SUBSTRING with column-based start position and length.
- Substring(Expression, int, int)
Initializes a new instance of SUBSTRING for a string expression with literal parameters.