KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a query where I generate our monthly customer contact activity. We have several categories (email out, email in, phone call in, phone call out, etc.) There are 8 distinct "type" results. I need to have two groups-one for all "email" and one for all "phone". Currently, I have a WHERE TYPE LIKE '%Email%'and TYPE LIKE '%Call%'. However, I am not able to group by these two "LIKE" statements. Does anyone know how I can best achieve this? I simplified the query down to this for the example: SELECT TYPE FROM dbo.HISTORY WHERE (TYPE LIKE '%email%') OR (TYPE LIKE '%call%')
Tags (comma-separated)
Save Edits
Cancel