Need filter based on field value - if contains, is in?

[rtucci_1]

 

I have a history report for incidents, the history table contains the lifecycle of the incident cases (who it was assigned to and when etc.)

The report needs to show all cases where a specific support group (value) exists. So if the field contains (X value) I need to see it.

I have tried Is Like or like, but it does not work, is there a "contains" SQL expression I can use?

[lisacbeaton]

You could try a regular expression (formatted for Oracle here -- the 'i' makes it case insensitive -- format to suit your own database):

REGEXP_LIKE(COLUMN_NAME, 'seach term', 'i')

[rtucci_1]

 

Unfortunately I am using a Sequel database, is there a similar function is SQL?

[rtucci_1]

 

Unfortunately I am using a Sequel database, is there a similar function is SQL?

[rtucci_1]

 

Unfortunately I am using a Sequel database, is there a similar function is SQL?

[rtucci]

This is how i resolved my issue by using a nested query

HPD_AssignmentTracking."Case_ID" IN ( SELECT DISTINCT HPD_AssignmentTracking."Case_ID" FROM "dbo"."HPD_AssignmentTracking" HPD_AssignmentTracking WHERE HPD_AssignmentTracking."Case_Assigned_To_Group" = 'DOITT:Service Desk' )

This shows me all cases where a specific support group has been assigned.