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. The LookupRows() function is a case-insensitive version of this function.

  • 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 for rows to retrieve. This value is case-sensitive.
  • searchValue1 (string): Required. The value 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.

MemberIdFirstNameSurnameRewardsPointsRewardsTierArea
1DennisSmithers923742Chelsea
2PoojaChatterjee2010421Hammersmith
3TomásSantos693113Kensington
4Sun-HiKim239994Twickenham
5JianYeh151234Chelsea

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: