Select statement

[Former Member]

Hi all,

I need to select data from a customized table.

for example the record in the customized table would look like this

machine     data1     data2     data3
A100001     SA1       SA2       SA3
A100002     SA4       SA5       SA6
B100001     SA7       SA8       SA9
C100001     SA1       SA2       SA3
B100001     SA4       SA5       SA6

How could the select statement to only select for only machine prefix is with "A". My expected data selected is

machine     data1     data2     data3
A100001     SA1       SA2       SA3
A100002     SA4       SA5       SA6

Thanks to all.

[Former Member]

Hello

Yes. Try like this:

select * from ztable where machine LIKE 'A%'.

[Former Member]

give

machine like 'A%'

or try

machine = 'A%'

in your where clause of select query.

[sridhar_meesala]

Hi,

Use the % operator with the SELECT statement.

SELECT * 
FROM table 
INTO itab 
WHERE machine = 'A%'.

Thanks,

Sri.

[Former Member]

Hello frn.

use like statement in where clause with select statement ...

select * from <database table name > where f1 like '%A' .

and Please try F1 on LIKE staement .... you will get solution .

Thanks ..Priyank

[Former Member]

hI,

You can try the following code.

SELECT * 
FROM IT_TAB 
INTO IT_TEMP
WHERE machine like 'A%'. 

Regards,

Vik

Edited by: vikred on Jul 23, 2009 7:14 AM

[sreeramkumar_madisetty]

Hi

Use SORT TABLE BY MACHINE.

SELECT *

FROM table

INTO itab

WHERE machine = 'A%'.

Regards,

Sreeram

[Former Member]

Hi,

select * from zdbtable into table it_tab where machine LIKE 'A%'.

[Former Member]

Hi,

SELECT machine

data1

data2

data3

FROM Ztable

INTO table ITAB

WHERE machine Like 'A%'.

Regards,

ShreeMohan