Special character(s) inside meta data

Hi,

First of all, in most cases I wouldn't design a database with "special character(s)" for meta data. But, I may be in a situation to handle database(s) like that. To be more specific, table name like
"%strange$tbl#name%", column name like
"weird&but(possible$column*s_at_name", that's what I'm talking here.
So, my question has two parts:
(a) since "special character(s)" inside meta data requires extra
"care", translation, extra work, it's MUCH less desirable from design
point of view.
Does that mean probably <5% corporate databases would be like this? Or is it a totally wild guess vs. educated guess? (b) what's a good strategy to tackle database like that from data retrieval point of view?

Thanks.

DCL Received on Wed May 29 2002 - 05:32:00 CEST