in mysql we have a option called as binary for case senstivity for columns in table.does any that type of option is there in sapdb.
string-comparisions in SAPDB are always case-sensitive.
you have a chance to do it with LIKE, but that will cause a table scan.
a future feature of SAPDB may be, to put an index on something like UPPER(column) so you should be using
WHERE UPPER(column)="ABC"
do that in future an index can be used.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
