SELECT statement

[Former Member]

Hi All,

I need to specify 2 conditions for BTRTL in select statement like btrtl should only be equal to both '1000' and '1001'.

How can we do this in a select statement.

thanks

[Former Member]

Hi

u can use BTRTL NE 1000 and BTRTL NE 1001

or

Not BTRTL in ('1000', '1001')

[Former Member]

Hi,

Thanks for the reply.

In my case btrtl equals to 1000 and 1001.

How can we do for this?

Thanks

[Former Member]

WHERE BTRTL in ('1000','1001') OR Where (BTRTL EQ 1000 OR BTRTL EQ 1001)

u can use this, it acts union - pick all the values where BTRTL is equal to 1000 or BTRTL is equal to 1001.

At same time single record cannot hold both values 1000 & 1001 in BTRTL rite

[Former Member]

Thanks everyone,i solved it

thank you very much

[Former Member]

> I need to specify 2 conditions for BTRTL in select statement like btrtl should only be equal to both '1000' and '1001'.

where ( BTRTL = '1000' or

BTRTL = '1001' ).

SOME THING LIKE THIS..

SELECT * FROM SFLIGHT

INTO FLIGHT

UP TO 1 ROWS

WHERE ( CARRID = 'AS' OR CARRID = 'BB' ).

ENDSELECT.

[Former Member]

WHERE BTRTL in ('1000','1001')