Hey Thank you for the help but when I right click the database I don't have the option to import data into my database. I'm running SQL Server Management Studio...

Thank you for the help however, when I apply these changes it gives me an error saying:

Msg 235, Level 16, State 0, Line 1

Cannot convert a char value to money....

Honestly, I'm not looking for the cheap way out I really want to learn this stuff and retain it. I would rather get a few hints like you have pointed...

Lowell,

You were totally right!!! 😀

You said,

it should be obvious that string cannot be converted to an integer right? undoubtedly there are other values in the table that are...

:w00t:

Lowell,

Thanks for the help so this is what happens when I try to input the data you gave me.

Code:

SELECT LastName, SUM(CONVERT(int, EEO1Classification))

FROM EmployeeInformation

GROUP BY LastName

Error:

Msg 245, Level 16, State...