Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing case of text?
- Thread starter Jen123
- Start date
I don't know of any way to get the results you are looking for using Teradata SQL. Defining a column as CASESPECIFIC or NOT CASESPECIFIC is as close as I think you are going to get.
By your example, it looks like you are trying to have the first letter of each word capitalized. Is this correct? I assume that this is a complete string from 1 column and not a concatenated string from multiple sources.
If it were a conctenated source I think it could be done, but it would take some creative/cumbersome SQL to do. (I have a few ideas of ways to do it floating around in my head right now, so I'd have to try them before I say how to do it or if it's even possible.).
By your example, it looks like you are trying to have the first letter of each word capitalized. Is this correct? I assume that this is a complete string from 1 column and not a concatenated string from multiple sources.
If it were a conctenated source I think it could be done, but it would take some creative/cumbersome SQL to do. (I have a few ideas of ways to do it floating around in my head right now, so I'd have to try them before I say how to do it or if it's even possible.).
- Thread starter
- #3
- Status