SQL does not return rows using variable in string

Here is my call using C#
Select JobStart, JobFinalized, OrderNumber, ArrivalMileage, TotalBill as TotalJobDollars " +
" from Workdata where ShopAbbrev = '" + tempShopAbbrev + "' and JobStart > '" + tempStart +
"' and JobFinalized <= '" + tempEnd + "' and Mechanic = '" + tempEmpName + "'

here is the actual sql command

Select JobStart, JobFinalized, OrderNumber, ArrivalMileage, TotalBill as TotalJobDollars from Workdata where ShopAbbrev = 'OTWELL1' and JobStart > '7/22/2013 12:00:00 AM' and JobFinalized <= '7/27/2013 12:00:00 AM' and Mechanic = 'Anthony Otwell'

This returns 0 rows

If I assign tempEmpName the value of 'Anthony Otwell' this call works. I have never seen this before. Has anyone ever experienced this and have a resolution.

This is where I get tempEmpName

string tempEmpName = EProductionDDL.SelectedItem.ToString();

Obviously tempEmpName is assigned the correct string as displayed in the actual sql command line ???

Ross Murray
[email protected]

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ross Murray13y ago
Thanks for the reply - I did just figure it out. It was imported data in the column and there were 2 spaces between first and last name - Thanks
Vulpes13y ago
A daft question perhaps but is it possible that the Mechanic field in the database could actually contain names embedded in single quotes such as 'Anthony Otwell' rather than just the name itself?