You're welcome. Note that if you reference an array only by it's name, you get the first element, which in your case is the only element.

>thanks guys! all set now.
>
>>Hi timothy,

>>SELECT count(*) FROM m:4vs WHERE date_l_in =today INTO ARRAY 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.