LookupRowsCS
Returns a rowset from a data extension where the field matches the specified value. The system treats strings as case-sensitive. Specify additional field value pairs as part of an AND clause. This function returns a maximum of 2000 rows. To better control the number or the order of returned rows, use the LookupOrderedRowsCS() function. This limitation enhances script performance.
Syntax
LookupRowsCS(1, 2, 3)
Function Properties
Ordinal | Type | Description | |
---|---|---|---|
1 | string | Required | Name of data extension from which to return specified rows |
2 | string | Required | Column name used to identify rows to return |
3 | string | Required | Value used to match rows to return |