Skip to Content
0
Former Member
Jun 08, 2009 at 04:42 AM

How to fetch the values with from and to

35 Views

Hi All,

in table(ZBOX) records are like this

field1 field2 field3 field4

523012 FGD100 FGD500 BOTTLE

523012 FGD501 FGD800 BOX

Now in selection parameters i am giving FGD200, Based on this value how to get the record(1st record) from Ztable(ZBOX).

please tell me how to write the select query regarding this.

Thanks in advance.