output. Original value column Extension is a text that I
want to add 2100, but I want to have it output to a text.
Using Northwind database, table Employees:
Expand|Select|Wrap|Line Numbers
- Select
- (E.EmployeeID) as 'EmployeeID_ab',
- (E.Extension) as 'Extension_ab'
- From Employees E
Expand|Select|Wrap|Line Numbers
- EmployeeID_ab Extension_ab
- 1 5467
- 2 3457
Expand|Select|Wrap|Line Numbers
- EmployeeID_ab Extension_ab
- 1 7567
- 2 5557