LookupRows()

Returns an unordered rowset from a data extension. The function can return a rowset with up to 2,000 rows. This function is case-insensitive.

AMPscript includes several variations of the LookupRows() function.

The LookupRows() 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-insensitive.
  • searchValue1 (string): Required. The value in the specified column that identifies the rows to retrieve. This value is case-insensitive.

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.