Greg Matthews wrote:
How do I make a SAPDB case-insensitive?
What do you mean?
If you mean: "How do I match a value case-insensitively?" Then there are two answers: 1) Don't, store the uppercase or lowercase version of the value and match that, this is good if you want to do large searches that need to be indexed. 2) Simply do: "select * from foo where upper(bar)=?" this is slow beause you can't index the bar column, so only use for small tables. -- Regards Flemming Frandsen - http://dion.swamp.dk PartyTicket.Net co founder & Yet Another Perl Hacker _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
