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 - 2002-07-09 : 08:04:11
|
| Michael writes "I have two questions actually:1. I have a table with text input that is all caps. I understand there is a function or procedure in SQL that will go through and change the caps to lower case except for teh first letter after spaces. I have not been able to find this books on line. I'm not sure what to do a search on to look for this function on line. Any help here would be appreceiated as it would be better than re-typing the data in the fields.2. From your frequently asked questions I gather SQL supports Arrays. I have not been able to find the structure to establish an array in my database. Again, any help here would be appreciated in pointing me to the right source.Thank you." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-09 : 08:59:56
|
| Actually there is no PROPER() function in SQL Server, but there are a couple of ways of achieving it:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=10107http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=15152SQL Server does not support arrays. But you can simulate arrays using comma-separated values (CSV):http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvYou can also use a table structure to simulate an array, but it is CRUCIAL to remember that a table is not exactly the same as an array and does not function the same way. |
 |
|
|
|
|
|
character data structure