Like with union
Approach\nLike with union\n\n# Code\n\n/* Write your T-SQL query statement below */\nselect patient_id, patient_name, conditions from patients\nwhere conditions
# Approach\nLike with union\n\n# Code\n```\n/* Write your T-SQL query statement below */\nselect patient_id, patient_name, conditions from patients\nwhere conditions like \'DIAB1%\'\n\nunion\n\nselect patient_id, patient_name, conditions from patients\nwhere conditions like \'% DIAB1%\'\n```
['MS SQL Server']