Database

rahmat1985 wrote:

as we all know

SELECT * FROM contacts WHERE (company_name like '%'+@searchText+'%' OR first_name like '%'+@searchText+'%' OR last_name like '%'+@searchText+'%')

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%'