MVSFORUMS.com

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

Hi,

I want to select rows from a table where the same field having both the values (Not either).

We have a table where a field can have multiple values.

Example:

dbzTHEdinosauer · Posted: Thu Dec 11, 2008 7:10 am Post subject:

????

it is a 3 char column.
So, how could 1 row contain a column,
which is defined as CHAR(03),
which has 6 char?

I don't understand how a 3 char column could contain 1ck and sck.
_________________
Dick Brenholtz
American living in Varel, Germany

CraigG · Posted: Thu Dec 11, 2008 7:19 am Post subject:

You could code it as "WHERE CONS_DATA_INSTNC = '1CK' AND CONS_DATA_INSTNC = 'SCK'"

a more efficient way whould that would return the same results would be
"WHERE 1 = 2"

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

CraigG, I have tried it with AND condition but gives me 0 rows Sad

_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

jsharon1248 · Posted: Fri Dec 12, 2008 10:34 am Post subject:

What kind of special DB options are you using that the column value on a row can contain 2 values? You need to think about what you're saying. It doesn't make sense.