How do I ignore the large and lower case when query?

Feb 1, 2009 at 7:52 PM
I have a field which contains text with large and lower case. How can I make a query which ignores large and lower case? The field is a string (varchar). I'm using Firebird 2.1.1
Coordinator
Feb 2, 2009 at 1:25 AM
I didn't have such requrement, but you may try LIKE :
  CK.K["Name"].Like("tom");
Or you can use sql directly.
Feb 2, 2009 at 5:44 AM
Currently I'm using the like method, but when I have an entry "Tom" the query can't find it when I use this: CK.K["Name"].Like("tom"); And, I don't want to use sql directly.
Coordinator
Feb 2, 2009 at 8:43 AM
DbEntry didn't support any database function for now.
So the possiable solution could be:
  add a column which same as "Name" but lower case the charaters named "NameLower"
  and use CK.K["NameLower"] == "tom"
Coordinator
Feb 5, 2009 at 9:12 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.