How to do a Union Query in SQL Server

Dear Experts,

I am using a VB.Net SQLDataSource to populate a combobox on a windows form. However in the bound combobox, I need to add one additional entry that displays "(none)" and has a value value of 0. I have tried to follow a couple of posts on the VB side that suggest inserting a new ListItem, but it does not accept ListItem as a valid type.

So I would like to try doing what I have done in Access previously and use a union query to add a static value row to the query itself. Something like:

Select Identified_Language_ID As ID, Print_Name as Name From Identified_Language Order By Print_Name
Union Select 0 as id, '(none)' as name from identified_Language;

But when I test this in SQL Management Studio, it complains: "Incorrect syntax near the keyword 'UNION'." Can anyone help me correctly formulate a query that retrieves values from a data table, and adds one additional row with a static value for the two fields?

Actualyl - you shouldn't need the table name in the union clause either
Select Identified_Language_ID As ID, Print_Name as [Name] From Identified_Language Union Select 0 as id, '(none)' as [name]
Order By [Name];