how to select number field starting with 99

[Former Member]

Hi Freinds-

I have to pick values for a number field but i want only those values which starting with 99

how i can put code in select query for this ?

Regards

Meeta & Ruby

[Former Member]

hi.

SELECT * FROM pa0001

WHERE kunnr LIKE '29%'

[former_member222860]

Hi,

Select fieldname into table itab from dbtable 
where fieldname like '99%'.

thanks\

Mahesh

[Former Member]

Hi,

Hope this will help u.

Select <ur field> from <tablename> into table <internal table>

where <fieldname> like '99%'.

Thanks.

[former_member313270]

Hi meeta,

If you are fetching data from table you can use the below SQl statement.In where condition you need to mention as below.

Select <ur field> from <tablename> into table <internal table>

where <fieldname> like '99%'.

Regards,

Dwara..

[I355602]

Hi,

Use the query as:-

select
   <field1>
   <field2>
from <database_table>
into table <internal_table>
where
   <field_name> like '99%'.

Hope this solves your problem.

Thanks & Regards,

Tarun Gambhir

[Former Member]

Select fieldname

from dbtable

into table itab

where fieldname like '99%'.

Regards,

Joan

[former_member222860]

Hi,

Are u justified / happy with the points awarded!!!

Cheers\

Mahesh

Edited by: Mahesh Reddy on Jan 19, 2009 2:09 PM