Skip to Content
0
Oct 27, 2007 at 09:53 AM

Problem with select range for a character type field. Kindly Help! Urgent!

223 Views

Hi Experts,

I have to write a report to pull data from a table BUT000 for a selected range of BPEXT field values in selection screen.

In the table BUT000, the BPEXT field is type char. Now what is happening is that if the user gives a range in selection screen from 1000 to 1010 the query pulls all the records where teh forst character starts from 1.

For example if the table has

BPEXT

-


1

10

100

101

1000

1001

1002

1005

1010

20

200

2000

Then my query pulls

BPEXT

-


101

1000

1001

1002

1005

1010

Instead it should pull only

BPEXT

-


1000

1001

1002

1005

1010

My guess this is because the BPEXT field is of CHAR type instead of numeric.

What shall i do to solve this problem? Kindly help please!

Thanks

Gopal

Message was edited by:

gopalkrishna baliga