Suppose I have a table:

```
Id int, 
Name varchar(10)

```

with values: 

```
(1, Nick), (2, Mike), (3, Eric)

```

I want to return all the names that are contained in a string. For example "Nick, Mick" would return Nick and Mike.

I've tried with `LIKE` but it works the other way around returning the values that contain a string.

I was hoping for somthing like this, but that it actually works.

```
SELECT * FROM table
WHERE Name.isContained("Nick, Mike");

```

Result: 

```
1, Nick and 2, Mike

```