AMPscript Data Extension Functions

Use the AMPscript Data Extension functions to create data extensions, retrieve data from data extensions, and modify data in data extensions.

This section contains information about these AMPscript functions.

Function Name	Description
ClaimRow()	Returns the first unclaimed row from a data extension.
ClaimRowValue()	Searches a data extension for an unclaimed row and returns a value from that row.
DataExtensionRowCount()	Returns the number of rows in a data extension.
DeleteData()	Deletes rows from a data extension in CloudPages, microsites, landing pages, and SMS messages.
DeleteDE()	Deletes rows from a data extension in an email.
ExecuteFilter()	Executes a data filter and returns an unordered rowset that contains the results.
ExecuteFilterOrderedRows()	Executes a data filter and returns an ordered rowset that contains the results.
InsertData()	Inserts rows into a data extension in CloudPages, microsites, landing pages, and SMS messages.
InsertDE()	Inserts rows into a data extension in emails.
Field()	Returns a specific field from a data row.
Lookup()	Returns a value from a data extension.
LookupOrderedRows()	Returns rows from a data extension sorted in ascending or descending order (case-insensitive).
LookupOrderedRowsCS()	Returns rows from a data extension sorted in ascending or descending order (case-sensitive).
LookupRows()	Returns an unordered rowset from a data extension (case-insensitive).
LookupRowsCS()	Returns an unordered rowset from a data extension (case-sensitive).
Row()	Returns a row from a rowset or array.
RowCount()	Returns the number of rows in a rowset or array.
UpdateData()	Updates data in a data extension in CloudPages, microsites, landing pages, and SMS messages.
UpdateDE()	Updates data in a data extension in emails.
UpsertData()	Upserts data in a data extension in CloudPages, microsites, landing pages, and SMS messages.
UpsertDE()	Upserts data in a data extension in emails.