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.
LookupRowsCS(1, 2, 3)
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 |