could someone please tell me how I can trim the below output to only the character that were before the .public.smp.com
SELECT t.target_name
FROM mgmt_targets t JOIN mgmt_current_severity s
ON s.target_guid = t.target_guid
WHERE t.target_name LIKE '%blah%'
AND t.target_type = 'oracle_database'

Result: "blah.public.smp.com"

and I would only need "blah" on my output.

Thanks,