there is no parameter that you can change as sapdb doesn't support case-insensitive searching. you have to code everything as the others have been giving you examples of.
cheers -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Francesco Pagano Sent: Saturday, March 22, 2003 12:33 PM To: Udo Ullrich Cc: [EMAIL PROTECTED] Subject: Re: problem with case-sensitive Select * from table1 where UPPER(name)='UDO' >>>>>>>>>>>>>>>>>> Notizia originaria <<<<<<<<<<<<<<<<<< Il 21/03/2003, 16.37.40, "Udo Ullrich" <[EMAIL PROTECTED]> ha scritto sull�argomento problem with case-sensitive: > Hallo > i want to change case-sensitive into not case-sensitive. > witch paramater must i change?? > SAPDB Version (windows) 7.4.3.10 > Example: > Select * from table1 where name='udo' > i want follow result: > udo > UDO > uDO > ... > Thanks > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
