I'm trying to assign a string result from a query into a trigger's string variable, and this is the error I receive:
Compile Error: Illegal assignment from LIST to String at line 42 column 12
// Most Recent SEM Code
SEMCODE = [select SEM_Code__c from Interaction__c where Contact__c = :record.Contact__c
ORDER BY Start_Date_Time__c Desc Limit 1];
How can I get the SEM_Code__c value from the single record query result?