>One thing I like and the other I don't. I like the suffix idea - if you maybe remember the Inverse Hungarian Notation thread, some time Summer'97, you may know what I mean. We've spilled lots of bytes over the subject at the time.

I'm sure you did. And I'm sorry I missed that. I enjoy arguing far more than programming. :)

The term "Hungarian notation" is actually rather tricky. Originally, Simonyi suggested using prefixes to identify _use_, not type. The current "lpsz" crap is counter to his original ideas. I don't use that kind of "Hungarian" in my C++ code, though I do use it in Fox (where the compiler can't tell me if I'm mismatching data types).

>I specifically want my, say, customer code to be called "custcode" no matter where it appears.

I generally favor that, myself.

>If they were prefixed, I'd have to do lots of "Select ... mbr_cust as dzw_cust" or write lengthy Insert ...values ... (mbr_this, mbr_that, ...).

I guess it depends on what kind of SELECTs you most commonly write. In your case, prefixes would slow you down. In my case, using prefixes avoids aliasing in SELECTs.