USE SPRINGFIELD;

SELECT BIN(2), BIN(5), BIN(99);

SELECT BINARY 2, BINARY 5, BINARY 99;

SELECT 'LOS SIMPSONS'='Los Simpsons';

SELECT BINARY 'LOS SIMPSONS'='Los Simpsons';

SELECT DESC_PERSONAJE
, ID_SEXO
, CASE WHEN ID_SEXO=1 THEN 'HOMBRE'
	WHEN ID_SEXO=2 THEN 'MUJER'
	ELSE 'DESCONOCIDO'
 END DESC_SEXO
FROM PERSONAJES;

SELECT CAST('1989-12-17' AS DATE), CONVERT('1989-12-17' ,DATE);

SELECT CAST('1989-12-17 20:30:05.000001' AS DATETIME), CONVERT('1989-12-17 20:30:05.000001', DATETIME);

SELECT CAST('20:30:05.000001' AS TIME), CONVERT('20:30:05.000001' ,TIME);

SELECT CAST(744 AS CHAR), CONVERT(744, CHAR);

SELECT COALESCE(null,null,null,'HOMER', 'MARGE');

SELECT COALESCE('LISA',null,null,'HOMER', 'MARGE');

SELECT COALESCE(null,null,null,null,null);

SELECT CONV(5,10,2), CONV(101,2,10), CONV(74,10,16), CONV(-74,10,-16);

SELECT IF(50<100, 'MENOR','MAYOR');

SELECT DESC_PERSONAJE, ID_LUGAR_PROFESION, ISNULL(ID_LUGAR_PROFESION) FLAG_NULO
FROM PERSONAJES;

SELECT NULLIF(5,5), NULLIF(3,5), NULLIF(5,3), NULLIF('SIMSPONS','simpsons'), NULLIF('SIMSPONS','SIMSPONS');

SELECT ENCRYPT('Simpsons'), ENCRYPT(null), ENCRYPT('Simpsons','1'), ENCRYPT('Simpsons','12')
, MD5('Simpsons'), MD5(null)
;