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 |
|
2639
Starting Member
6 Posts |
 Posted - 2006-08-18 : 21:27:47
|
| I wrote this simple sp and I'm sure there's a better way to acomplish my desired results:SELECT manufacturer_id, url, dbo.Proper(manufacturer_name) AS manufacturer_name, dbo.Proper(address_1) AS address_1, dbo.Proper(address_2) AS address_2, dbo.Proper(city) AS city, UPPER(state) AS state, zip, main_phone, date_added, date_modifiedFROM manufacturersORDER BY manufacturers_namedbo.Proper is a user-function that converts each word's first letter to caps and each other to lower. My delima is that it LOOKS convoluted. Is it as sytactically correct as can be?Thanks.Andy |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 23:34:18
|
| Look ok to me. And if it runs in a timely fashion, well, go with it.Peter LarssonHelsingborg, Sweden |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-21 : 00:30:33
|
| If you use Front end application like VB, make use of String convert function which does the same scopeMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
Is there a better syntax for this?