I want to search a string if it exists in a data table and return the rows. For example I have a data table with fields like User Name, User Password,....etc. Now my search text will search all the fields and return me the rows which contains the string.

Can anyone please help on this.  

I googled on it.  

I found couple of solution, one was 

```
Select("Code LIKE '" + lastWord + "%'" );  

```

But here I am confused with "Code".

Regards