[RESOLVED] [Oracle 10g XE] Case Insensitive field

[nmadd]

Hi all,
I'm playing around with the sample database in Oracle 10g XE. I'm trying to select records based upon the text DEPARTMENT_NAME field in a case insensitive manner. For example, if I search for "admininstration" I would like it to match the "Administration" department.
I have this working in this fashion, but just wondering if there is some built-in property in the command or if this is it? Thanks.

        Dim SQLString As String = _
            "SELECT * " & _
            "FROM departments " & _
            "WHERE UPPER(department_name) = :deptName"

        Dim cmd As New OracleCommand(SQLString, conn)
        cmd.Parameters.Add(New OracleParameter("deptName", (Me.TextBox2.Text).ToUpper()))

[GaryMazzone]

Oracle searchs for text are always case sensitive. (Maybe a hold over from Unix liniage). When I was doing Oracle every day we stored all text data (in one word fields like department) into Uppercase (Upper()). Then always cast the query search value to UPPER() also. You can do it on the fly as you did but Oracle will not use any indexes when you do that. If there are is a lot of data in the table and a full table scan results it can cuase a slow down to the view of the user.

[nmadd]

Thanks for the info Gary.