Cust_Rcrd_Value

Returns the value of a field in the CUST_RCRD table using parameter values to select the row.

Arguments

Cust_Rcrd_Value( <Record_Class> , <key> , <field> )

Example

Cust_Rcrd_Value( "Airline Codes" , "UA" , "%T003" )

The function searches the CUST_RECORD table for a single row where RCRD_CLASS has the value "Airline Codes" and RCRD_KEY has the value "UA", and returns the value of column %T003. Null is returned if no row is found.