Hi Dorin

Thanks a lot for your help and the code for the same. I am working on implementing it.

>If parameters are numeric, then you can do something like this
>View code:
>

SELECT SPACKINGLISTITEMS.*, ;
>	FROM VSO3!SPACKINGLISTITEMS ;
>	WHERE SPACKINGLISTITEMS.IPID BETWEEN ?VP_IPID_1 AND ?VP_IPID_2

>
>Before USEing the view:
>

>m.vp_ipid_1 = 0
>m.vp_ipid_2 = 2147483647
>
>lnParameter = INPUTBOX('Enter ID value','Parameter value')
>IF !EMPTY(lnParameter)
>    IF TYPE('lnParameter') = 'N'
>        STORE lnParameter to m.vp_ipid_1,m.vp_ipid_2
>    ENDIF
>ENDIF
>