>Try
>
>

>lc_sealnumber = ALLTRIM(thisform.lc_sealnumber)
>
>lc_sqlstring = "SELECT * FROM view_depositactivity WHERE postingdate BETWEEN ?ld_startdate AND ?ld_enddate "
>lc_sqlstring = lc_sqlstring + " AND sealnumber LIKE '%' + ?lc_sealnumber +'%'"
>= sqlprepare(gnconnhandle, lc_sqlstring, "curactivity")
>IF oApp.gf_sqlexec(gnconnhandle)
> 
>  SELECT curactivity
>  GO TOP
>  BROWSE
>
>ENDIF 
>
>
>

To be more precise and to avoid errors I recommend to make sure that the variable is declared private and not local:

PRIVATE pc_sealnumber
pc_sealnumber = ALLTRIM(thisform.lc_sealnumber)

lc_sqlstring = "SELECT * FROM view_depositactivity WHERE postingdate BETWEEN ?ld_startdate AND ?ld_enddate "
lc_sqlstring = lc_sqlstring + " AND sealnumber LIKE '%' + ?pc_sealnumber +'%'"