SQL Searchin not case sensitive

[Trausti Thor Johannsson]

Hello,

I have this code in my software :

cursor = mDataBase.SqlSelect("select * from simptable where ((texti  
like '%"+leitarstrengur+"%') or (filename like '%"+leitarstrengur 
+"%'))",EVCursorLocation.kServerSide, EVLockType.kReadWrite,  
EVCursorDirection.kRandom  )


I would like to search for texti and not search case sensitive, so  
people could type "php" or "PHP" or "pHp" and still get the same  
results.  This above works quite well with other databases, but how  
do I do not case sensitive ?


I am using RealBasic 2007 pro on Mac.


Best regards,


Trausti