SELECT transaction_id FROM TRANSACTIONS WHERE transaction_type_code  =  'PUR'
Show all transaction ids with transaction code 'PUR'.
SELECT transaction_id FROM TRANSACTIONS WHERE transaction_type_code = 'PUR '
select transaction_id from transactions where transaction_type_code = value
Show all transaction ids with transaction code 'PUR ' .