Select Query

[Former Member]

Hi,

I have written the following select query in my code :

select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA*' and ddlanguage = 'E'.

The query is not retrieving any records. Can you please help.

Thanks,

Sachin.

[Former Member]

Hi,

I have written the following select query in my code :

select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA*' and ddlanguage = 'E'.

The query is not retrieving any records. Can you please help.

Thanks,

Sachin.

[Former Member]

Corrected code...

select tabname
          ddlanguage 
          as4local 
          as4vers
          ddtext
    from dd02t
    into table i_tdata 
    where tabname like 'LA%' and 
             ddlanguage = 'E'.

[Former Member]

Thanks Vijay and all of others. It worked.

[Former Member]

hi,

do this way ..

select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA%' and ddlanguage = 'E'. 

[JozsefSzikszai]

hi,

pls. try:

tabname like 'LA%'

(percentage instead of asterisk)

hope this helps

ec

[Former Member]

Try this:

select tabname ddlanguage as4local as4vers ddtext from dd02t into table i_tdata where tabname like 'LA%' and ddlanguage = 'E'.

Regards,

Joy.

[Former Member]

tabname like 'LA%'

[Former Member]

Hi,

Use % symbol instead of *