05-26-2006 9:56 AM
Hi all
i need to fetch all those records for output_type
having the value "SNAIL MAIL" and ' Snail MAil'
how can i specfy this in the where clause
Thanks
SAI
05-26-2006 9:59 AM
hi Sai,
data : var1(10) type c value 'SNAIL MAIL',
var2(10) type c value ' Snail MAil'.
select .... where ( field = var1 or field = var2 ).
Regards,
Santosh
05-26-2006 9:59 AM
Hi sai,
1. U can give OR Condition in brackets.
2. eg.
Where
( field = 'SNAIL MAIL' OR FIELD = 'Snail MAil' )
regards,
amit m.
05-26-2006 10:00 AM
select * from <dbtab> into <itab>
where output_type = 'SNAIL MAIL' OR
output_type = Snail MAil'.
(or)
select * from <dbtab> into <itab>
where output_type IN ('SNAIL MAIL', Snail MAil').
05-26-2006 10:01 AM
hii
Select * from <databse table>
into itab
where database-field = 'SNAIL MAIL' and
database-field = 'Snail MAil'
05-26-2006 10:02 AM
Hi,
where
( field = 'SNAIL MAIL'
OR FIELD = 'Snail MAil' ).
Regards
vijay
05-26-2006 10:06 AM
hi
Select * from <databse table>
into table itab
where database-field = 'SNAIL MAIL' or
database-field = 'Snail MAil'
05-26-2006 10:07 AM
Hi,
If u want to select data without taking care of the case.
then u can do this.
DATA letters(10) TYPE C.
MOVE 'snail mail' TO letters.
TRANSLATE letters TO UPPER CASE.
then use in where clause.
select * from ...
into table itab
where field = letters.
or if this is not the case then u can use any of the above statements.
Reagrds