TEST

Brandon Harmon

The code SELECT dictionary_code, dictionary_value INTO :CODE, :VALUE FROM dictionaries_patient WHERE field_number = '5' AND (dictionary_code LIKE '%IP2' OR dictionary_code = '106ST2') would return the following values:

CODE VALUE

1 106ST2

SELECT dictionary_code, dictionary_value INTO :CODE, :VALUE FROM
dictionaries_patient WHERE field_number = '5' AND (dictionary_code LIKE '%IP2'
OR dictionary_code = '106ST2')