Hi all...
I need help in formatting a sql query.
I have a table EMP in SQL Server as below.
ID
| FName
| LName
| Salary
|
1
| ABC
| PQR
| 12
|
2
| DEF
| STU
| 23
|
Now, I want to fire a query in a way that I get the results in the following format -
ID - FName
1 - ABC
2 - DEF
-----------
I am not able to get that "-" sign. PLease Help.
Thanks in advance.