>Hello, i have a query that i tryng to compare with a variable that always changes, this the query:
>
>NUMERO=ARREGLO(I,1)
>
>SELECT ATENCION.FINICIO, ATENCION.FFIN FROM ATENCION WHERE ATENCION.NUMERO=(&NUMERO) INTO ARRAY PAUSAARRAY
>
>And it displays the next message error, how do i fix this?
>Thanks for the help.

If your NUMERO variable already contains the necessary value, you don't need the brackets and & symbol. I would also suggest to change the variable name since it is the same as a field name, or at least use m. prefix like m.numero

SELECT ATENCION.FINICIO, ATENCION.FFIN FROM ATENCION WHERE ATENCION.NUMERO = m.NUMERO INTO ARRAY PAUSAARRAY