collation - DB2 accent insensitive queries -

is there way of getting accent insensitive results in select query in db2?

the version of db2 database v6r1m0.

thanks

you change case of column , value looking for.

for example

select upper(lastname) mytable upper(name) = upper('john') 

you can use:

• upper

• translate

• ucase

however, not sure if these functions available in old db2 version. plan upgrade!