LookupRowsCS()
Returns an unordered rowset from a data extension. The function can return a rowset with up to 2,000 rows. This function is case-sensitive.
AMPscript includes several variations of the LookupRowsCS()
function.
- The LookupRows() function is a case-insensitive version of this function.
- The LookupOrderedRows() function allows you to specify a column and direction to sort the rowset by.
- The LookupOrderedRowsCS() function is a case-sensitive version of
LookupOrderedRows()
.
The LookupRowsCS()
function has three parameters.
dataExt
(string): Required. The name of the data extension that contains the data that you want to retrieve.searchColumn1
(string): Required. The name of the column to search. This value is case-sensitive.searchValue1
(string): Required. The value in the specified column that identifies the rows to retrieve. This value is case-sensitive.
You can optionally append additional search columns and values to the end of the parameter string.
This example uses a data extension called "MembershipRewardsProgramme," which contains the data in this table.
MemberId | FirstName | Surname | RewardsPoints | RewardsTier | Area |
---|---|---|---|---|---|
1 | Dennis | Smithers | 92374 | 2 | Chelsea |
2 | Pooja | Chatterjee | 201042 | 1 | Hammersmith |
3 | Tomás | Santos | 69311 | 3 | Kensington |
4 | Sun-Hi | Kim | 23999 | 4 | Twickenham |
5 | Jian | Yeh | 15123 | 4 | Chelsea |
This code retrieves a list of members where the value of the Area column is Chelsea
.
The code example outputs an unordered list of results.