Database

SELECT * 
FROM contacts
WHERE (contact_name LIKE '%John%' OR contact_name LIKE '%Dell%')
 OR (company_name LIKE '%John%' OR company_name LIKE '%Dell%')
 OR (service_offered LIKE '%John%' OR service_offered LIKE '%Dell%')

string BuildQuery(string searchText) {
    string sqlQuery = "SELECT * FROM contacts WHERE ";
    string[] words = searchText.Split(" ".ToCharArray());
    foreach(string word in words) {
        sqlQuery+= string.Format("(contact_name LIKE '%{0}%' OR company_name LIKE '%{0}%' OR service_offered LIKE '%{0}%' ) OR ", word);
    }
    sqlQuery = sqlQuery.SubString(1, sqlQuery.Length-2);
    return sqlQuery;
}

Jassim Rahma wrote:

so I want to be able to split all and search

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%Employee%'

SELECT COUNT(distinct FITEMNO)
FROM ARTRS01.dbf
WHERE FCUSTNO=@FCUSTNO

SELECT  item,sum(qty) as qty
FROM    MyTable
GROUP BY item