[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()))