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

Answer 1

Do you mean like this ?

SELECT UPPER(CustomerName) AS UppercaseCustomerName
FROM Customers;

https://www.w3schools.com/sql/func_sqlserver_upper.asp

Answer 2

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.

Answer 3

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

Answer 4

i hope i discribed the problem enough to understand)
my poor english
but anyway thank you, sneeze