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 |