SELECTcount(*) FROM m:4vs WHERE date_l_in =today INTOARRAY zz
yournumberofrecords=zz
>I am trying to put the value of an sql count(*) operation into a variable rather then a table, can this be done? > >I've tried "SELECT count(*) FROM m:4vs WHERE date_l_in =today to y1" but I'm not getting a figure when I know it's >1.