From jet to t-sql

[steve]

hello

I've got a problem using a T-sql syntax.
The jet syntax goes:
SELECT 0,"<<Add new>>" FROM employees
UNION (SELECT DISTINCTROW employees.id,employees.lastname & ", " &
employees.firstname from employees);

Can someone tell me how it goes in T-SQL


thanks
steve

steve

 

[giorgio rancati]

-----
SELECT ID,lastname + ', ' + firstname
from employees
UNION
SELECT 0,'<<Add new>>'