SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE tblEmployee ([EmpNo] int, [FullName] varchar(20), [Nickname] varchar(10), [Age] int, [Position] varchar(20), [Salary] float; INSERT INTO tblEmployee ([EmpNo], [FullName], [Nickname], [Age], [Position], [Salary]) VALUES (1001, 'Justin Bieber', 'jb', 30, 'Supervisor', 50000.00), (1002, 'Arian Grande', 'riri', 25, 'Manager', 30000.00), (1003, 'Selena Gomez', 'lena', 23, 'Programmer', 20000.00), (1004, 'Taylor Swift', 'swiftee', 20, 'Clerk', 10000.00); SELECT Nickname, UPPER(Nickname) FROM tblEmployee