Relative Content

Tag Archive for sql-servert-sqlcasting

Why is T-SQL casting is evaluating rows that are not there

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?