why is tsql casting is evaluating rows that are not there
I’m hoping fresh eyes can spot something that I’m not seeing…when I run the highlighted sql below it returns one row, the one I would expect it to. When I run the second sql below, casting schoolNumber and routeSchoolNumber as ints, I get an error saying it cannot convert ‘LAKE TERRACE’ to an int, but that’s not even in the row it’s evaluating?