how to configure my database or server to be case-insensitive

Hi,

Is there anyway to configure my database or server to be case-insensitive? In other words, I would like my database or server to ignore case while doing
text literal comparsion in all SQL statements. For example, the following criteria in where clause will return the same result:

    SELECT * FROM user_table WHERE use_name= 'john'
    SELECT * FROM user_table WHERE use_name= 'John'
    SELECT * FROM user_table WHERE use_name= 'JOHN'
    SELECT * FROM user_table WHERE use_name= 'jOhn'

Thanks,

Rick Lin
Diffusion, Inc.
rlin_at_diffusion.com Received on Fri Oct 23 1998 - 00:00:00 CDT