MVSFORUMS.com

db2beginer · Beginner Joined: 24 Feb 2004 Posts: 1 Topics: 1

I have a table INFO with three columns in db2.

Table Name Field Type
Name char
Loc char
Profession char.

Column Name has the following fields
A
B
C
D
E
F
G

When I execute this query I get nothing back.

Select *
from INFO
where Name > 'B'
ORDER BY Name;

Thanks for your help in advance.

vini · Posted: Tue Feb 24, 2004 6:24 pm Post subject:

Are you sure the Column Name is of length 1 and having those list of values in its Position 1 ?
Maybe not !

kolusu · Posted: Mon Mar 01, 2004 2:51 pm Post subject:

db2beginer ,

DB2 is case sensitive. So if your table has all values in lower-case then your query will result is zero rows as lower-case values are not greater then Upper-case 'B'

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu