> -----Original Message-----
> Thanks George,
> Was hoping for something simpler but that'll work.

You could do it with an external table.

The process would be something like:

1) Wrap sever start-up in an 'script'

2) in script, set an fixed-field text file to the value returned by
'shell echo $STORE_NUMBER'

3) then start server

4) In the DB, declare an external table point to the above text file.

5) then to get your environment variable I'd be a simple select
fieldname from external_table..

All the other options that I can think of off the top of my head involve
Stored Procedures with (hard-coded STORE_NUMBER), or some sort of
programming/compiling (ie UDF, or hacking Firebird to support the
environment variable somehow)

George

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 10/16/2003