>>Is it possible to create constants in SQL 7. I'm thinking it might be a good idea to try and define global variables in a system procedure and use them as constants. Is there a better way?
>>
>>Thanks
>>Miles
>
>Why not just create a table and put the declarations in there...

I'm not sure how well that would work. Values in the table need to be returned in a result or result set at the beginning of each procedure.