Process results of ExecuteSQL

     You need to specify field and record separators instead of using "" for each.

     Can you explain exactly what you mean by "take out each value"? I can think of several different things that you might mean by that. It may help to explain what you want to do with the results of this query.

     If a calculation field named cQuery is defined as:

     Let ([

              $query = "SELECT Description, Price, EUQ

                                FROM PriceBook

                                WHERE CatalogNumber LIKE ?"

             ; $result = ExecuteSQL($query; ¶ ; ""; fkCatalognumber)

     ];

             .....

            $result

     )

     Then Set Variable [$Description ; value: GetValue ( cQuery ; 1 ) ]

     will assign the value of Description from your query to the variable named $Description.