Question

为什么在sql sever中使用ucase函数会报错，报错为；'ucase' 不是可以识别的 内置函数名称。

create table firstl
(orderdate date,
orderprice int);
alter table firstl add customer varchar(20);
insert into firstl values('2008/12/29','1000','bush');
insert into firstl values('2008/11/23','1600','carter');
insert into firstl values('2008/10/05','700','bush');
insert into firstl values('2008/09/28','300','bush');
insert into firstl values('2008/08/06','2000','adams');
insert into firstl values('2008/07/21','100','carter');
select ucase(lastname)as lastl,firstname from persons;
不好意思，上述填写错误，应该为：
create table firstl
(orderdate date,
orderprice int);
alter table firstl add customer varchar(20);
insert into firstl values('2008/12/29','1000','bush');
insert into firstl values('2008/11/23','1600','carter');
insert into firstl values('2008/10/05','700','bush');
insert into firstl values('2008/09/28','300','bush');
insert into firstl values('2008/08/06','2000','adams');
insert into firstl values('2008/07/21','100','carter');
select ucase(customer)as lastl from firstl;

Answer 1

sql 字母转换大写函数 upper

Answer 2

没见过这个函数，是其他数据库吧，什么作用的呢？

追问

不好意思，填写错误：
create table firstl
(orderdate date,
orderprice int);
alter table firstl add customer varchar(20);
insert into firstl values('2008/12/29','1000','bush');
insert into firstl values('2008/11/23','1600','carter');
insert into firstl values('2008/10/05','700','bush');
select ucase(customer)as lastl from firstl;
正确的为这个，ucase是将小写的全部改为大写

追答

sqlserver中是upper()这个函数