Case of strings

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: simon(dot)windsor(at)cornfield(dot)org(dot)uk

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.