Hi, I use DB2 for AS/400.

Right now we use iSeriesNavigator v5r4.

When I run this sample query I get no results:

SELECT *
FROM MyTable
WHERE LastName = 'smith'

But this will return many results:

SELECT *
FROM MyTable
WHERE LastName = 'Smith'

I've tried adding SortSequence/SortType to my connection string (I'm using ASP.Net) and its still case sensitive. Any recommendations?

WHERE UCASE(LastName) = 'SMITH'
or
WHERE UPPER(LastName) = 'SMITH'
or
WHERE LCASE(LastName) = 'smith'
or
WHERE LOWER(LastName) = 'smith'

That could work, but this just seems quite messy to me! Is there a smoother way to tackle this?

WHERE LastName in ('Smith', 'smith' ...
would be more 'performance oriented' as there would be no function against every row.

When I met the same problem 2 years ago and try to solve by

it was created the big performance issue.

After this I found the solution without any performance affect:

Kara