Not a vb person myself but would a hash do that then: my %enum = ( ASSET => 1, LIABILITY => 2, EQUITY => 3, REVENUE => 4, EXPENSE => 5, DIVIDEND => 6, CONTRA_ASSET => 11, );
Or is Vb's enum like mysql's enum? I ask since you where doing a select and I don't know if that is a database thign or a function or something built in that's just called select. You might also want to look at constants, I've never really used them but they seem to sound like what you're describing, (IE a FILEHANDLE looking string that refers to a piece of data) HTH DMuey -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]