>When I run this query from the Query analyzer, I get the all rows within those dates where the sealnumber contains 123
>
>>>SELECT FROM view_depositactivity WHERE postingdate BETWEEN '2011-03-01' AND '2011-03-15' and sealnumber LIKE '%123%'
>
>I'm trying to pass the 123 as a ? argument in a SQL passthru query and can't figure out how to do it.
>
>When I just have the dates in the query I get the right answer.
>
>I'm getting no records back when I use the LIKE clause for the sealnumber
>
>The code below is my latest futile attempt
>
>Any suggestions?
>
>

>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 
>
>
>

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