[GENERAL] Case of strings

[Simon Windsor]

Hi   I have moved an application from MySQL to PgSQL, and after the making changes I thought all was ok.   However, I have just realised that   Where A = ‘STRING’   Is not the same as   Where A =’String’   Is there anyway I can force the PgSQL to accept case equivalence, or must I add upper()/lower() to force the case and then make string tests?   Ie Where upper(A)=upper(‘String’)   Many thanx   Simon   Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599   -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support.