Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to select numbers

p244500
Active Contributor
0 Kudos
150

hai all

i hav som two problems

1. i have data in BSEG table HKONT feild... like this

0000141004

0000141005

0000141006

0000315120

0000141008

0000315120

0000141009

0000515121

i want to select only 141* number .... how should i do it? 141......(141004,141005,141006, 141*......

2. my second problem is after the select 141..... number i want to get 141..4 ,141..5

so how should i do it?.... ex 141004, 141005 ....want to select all 141....last number 5 or 6 or 6....

regard

nawa

5 REPLIES 5

Former Member
0 Kudos
66

Hi,

1) you can use LIKE statement in the select statement.

Ex.

SELECT * FROM BSEG INTO TABLE T_BSEG

WHERE HKONT LIKE '0000141%'.

Thanks,

Naren

former_member196280
Active Contributor
0 Kudos
66

a)Use LIKE 141%

Former Member
0 Kudos
66

hi nawanandana,

u can write select statement like this,

select * from bseg into <itab> where HKONT ge '141000'

and HKONT le '141999'.

try this,

regards,

seshu.

sreeramkumar_madisetty
Active Contributor
0 Kudos
66

Hi

Use the following condition in your select statatement.

<b>WHERE HKONT LIKE '0000141%</b>

Regards,

Sree

p244500
Active Contributor
0 Kudos
66

hai

my problem is solve... thnx to every one

regard

nawa