Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 21:50:38
|
| Wayne writes "I have written an application that uses SQL 2000 to store specifications for speaker cabinets. The table is designed so that the each column name is a specification and an ID field joins to another table to get the speakers name and category. The problem is that the specifications require symbol characters in their names like: Frequency Response (Hz +/-3dB). Usually, I replace spaces with underscores in the column name, and use the REPLACE function to display the name grammatically. But there are simply too many kinds of symbols used to replace all of them. Is there any way to retrieve the value given to the description field of a column? Or is there any way to get symbols like ‘@,%,/,(,),°,+,-‘ in column names?" |
|
|
|
|
|
Is it possible to view a column's description?