Hi, When I do a search in a DB2 database table using a SQL string, for example, select * from table1 where column1 like 'Abc'. Does the select condition in the where clause (e.g., 'Abc' in the above example) case sensitive or not? If is case sensitive, then how can I select everything from the table containing abc regardless the case of the characters?
to avoid case sensitivity you can use a DB2 procedure in your query (example is using Oracle) like: "select * from table where UPPER( column1 ) like UPPER( '" + string_val + "') "); *note: UPPER is the Oracle procedure for upper case conversion, not sure what the equivalent DB2 procedure is You can find out if the column is case sensitive by doing some test queries. Jamie
You only have to be concerned about the DATA regarding case. For reserved words and metadata it doesn't matter ('cause DB2 is going to treat those as uppercase anyways). (Just throwing in my two cents worth)