case sensitive

Hi,

        Is there a function in SQL which doesn't care of the case of a string when you use a SELECT statement.

e.g: with a record containing the string TOTO

        i want to retrieve it with         

                select * from table_name where field_name='toto'

                Thanks in advance.

mailto:david.baratte_at_uhb.fr Received on Thu Jul 03 1997 - 00:00:00 CDT