topic Re: Where clause in Application Development and Automation Discussions

Where clause

Former Member — Fri, 26 May 2006 08:56:20 GMT

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

Re: Where clause

Former Member — Fri, 26 May 2006 08:59:31 GMT

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

Re: Where clause

Former Member — Fri, 26 May 2006 08:59:36 GMT

Hi sai,

1. U can give OR Condition in brackets.

2. eg.

Where

( field = 'SNAIL MAIL' OR FIELD = 'Snail MAil' )

regards,

amit m.

Re: Where clause

hymavathi_oruganti — Fri, 26 May 2006 09:00:02 GMT

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').

Re: Where clause

Former Member — Fri, 26 May 2006 09:01:21 GMT

hii

Select * from <databse table>

into itab

where database-field = 'SNAIL MAIL' and

database-field = 'Snail MAil'

Re: Where clause

Former Member — Fri, 26 May 2006 09:02:08 GMT

Hi,

where
  ( field = 'SNAIL MAIL' 
OR FIELD = 'Snail MAil' ).

Regards

vijay

Re: Where clause

Santosh_Kezkhepatmelathil — Fri, 26 May 2006 09:06:06 GMT

Select * from <databse table>

into table itab

where database-field = 'SNAIL MAIL' or

database-field = 'Snail MAil'

Re: Where clause

Former Member — Fri, 26 May 2006 09:07:53 GMT

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