LookupOrderedRowsCS
Returns a specified number of rows. Treats any string value in a case-sensitive manner. You can specify multiple additional field and value pairs as part of an AND clause. The function returns an empty set when no values match.
LookupOrderedRowsCS(1, 2, 3, 4, 5)
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | Name of data extension from which to return specified rows |
| 2 | numeric | Required | Number of rows to return. A value less than 1 returns the default 2000 rows. This limitation enhances script performance. |
| 3 | string | Required | Defines order of return as field ASC or field DESC |
| 4 | string | Required | Field to use to build WHERE clause |
| 5 | string | Required | Value to use to build WHERE clause |