---

Date Posted: 11/4/09

ok, there is a problem with the search program.  It is now case sensitive for some reason and it has to do with the new database that I am using.  In short some results might not be displayed when doing a search.  I am trying to figure this out.

UPDATE: I just need to convert it from

SELECT ID, summary FROM memoblog WHERE lcase(concat(ID,summary)) LIKE '%terts%'
to
SELECT ID, summary FROM memoblog WHERE lcase(concat(cast(ID as char),summary)) LIKE '%terts%'



TAGS: none