Database

Mycroft Holmes wrote:

You should be storing the data as a datetime TYPE not a string

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

Eddy Vluggen wrote:

SQLite does not have a DATETIME datatype

Eddy Vluggen wrote:

SQLite does not have a DATETIME datatype

Bernhard Hiller wrote:

Hard to believe, but true. Poor guys who have to deal with such crap!

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

PIEBALDconsult wrote:

And have you looked at Sql Server LocalDB?

PIEBALDconsult wrote:

I'll stick with SqlCe when given a choice; better to have features I don't use
than miss features I want.

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

Eddy Vluggen wrote:

replacing all those SqlCe's with Sql-express versions

Bernhard Hiller wrote:

have to deal with such crap

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