I'm using a select statement that combines two columns, EmployerID and Name as such:

```
SELECT EmployerID + '-' + Name AS CompanyName FROM Employer

```

to be put into a drop down list from the database. 
I have no issue selecting and filling the database, however, I need to use the EmployerID which is a foreign key of the Employee entity to select respective employees that belong to said employer by using 

```
string x =ddlEmployer.SelectedValue.ToString();
SqlCommand EmployeeCmd = new SqlCommand("SELECT EmployeeNo + ' - ' + Name As EmployeeName From Employee Where EmployerID = @SelectEmployer", conn);
EmployeeCmd.Parameters.AddWithValue("@SelectEmployer", x);

```

I cannot select it as doing a select statement of the selected value using the CompanyName combined values would not return anything be it making it equals or like as shown above.

So my question is, after selecting these two and displaying them as a single option in a dropdownlist, how would I then use the selected value to search for the EmployerID that is supposed to exist?