SELECT employee_id, UPPER (last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE UPPER (last_name) = 'higgins';
lunes, 31 de octubre de 2016
UPPER
La función de UPPER convierte todas las letras en la cadena especificada en mayúsculas. Si hay caracteres en la cadena que no son letras, no se ven afectados por esta función.
SELECT employee_id, UPPER (last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE UPPER (last_name) = 'higgins';
SELECT employee_id, UPPER (last_name), department_id
FROM employees;
SELECT employee_id, last_name, department_id
FROM employees
WHERE UPPER (last_name) = 'higgins';
0 comentarios:
Publicar un comentario