+ 1

Can we use function "upper" for name when giving name to column using "as"

13th May 2019, 6:12 PM
Maksim
Maksim - avatar
4 Antworten
+ 1
Do you mean like this ? SELECT UPPER(CustomerName) AS UppercaseCustomerName FROM Customers; https://www.w3schools.com/sql/func_sqlserver_upper.asp
13th May 2019, 7:02 PM
sneeze
sneeze - avatar
+ 1
When I use it in a view, I get error that it is not allowed. A.Name AS UPPER('name') //get an error A.Name AS UPPER(name) //get an error in this link it is used https://use-the-index-luke.com/sql/where-clause/functions/case-insensitive-search That is in a different place in a query ALTER TABLE employees ADD last_name_up AS UPPER(last_name) I tried it in a view and can't get it to work.
13th May 2019, 8:17 PM
sneeze
sneeze - avatar
0
no, i mean what function can we use to make text after 'as' appear in upper case. not only the result from (Customername) but the column name 'Uppercasecustomername' to. instead of using capslock
13th May 2019, 7:47 PM
Maksim
Maksim - avatar
0
i hope i discribed the problem enough to understand) my poor english but anyway thank you, sneeze
13th May 2019, 9:21 PM
Maksim
Maksim - avatar