Basic search
Select * from [Table1] Where [Column1] Like '% String1%'
2. Multi-column search
Select * from [table1] where ([Column1] [Column2]) LIKE '% String1%'
3. Multi-valued and search
Select * from [Table1] Where [columnς] Like '% String1% String2%'
4. Multi-valued or search
Select * from [table1] where ([columnς] Like '% stringς1%') or ([columnς] Like '% stringς2%')
Note: Do not have to beware of the English alphabet of the data and the problem of data.