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 |
|
devisetti
Starting Member
30 Posts |
 Posted - 2008-04-09 : 07:35:14
|
| Hi I am trying to output the data in the table to uppercase. I am using bcp to output as text file.Any possible solution to convert the data to uppercase from the table.Any tsql code for thisThanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 07:39:29
|
UPPER() function
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-04-09 : 07:42:42
|
| Select upper(Col1), upper(col2)..... from tablenamePrakash.PThe secret to creativity is knowing how to hide your sources! |
|
|
|
devisetti
Starting Member
30 Posts |
Posted - 2008-04-09 : 07:53:24
|
| I need a generic procedure because as I need to change lot of procedures to convert to uppercase . This might help me in reducing writing upper function for each column.Thanks very much |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-09 : 09:06:11
|
| Then you need to update data in the table in upper caseMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Convert to uppercase the data in table