Hello experts I have a fun project that I have inherated.... it involves a table that was built 3 years ago and the designer used CHAR and not VARCHAR.... here is my situation
My current statement
select Semester + SchoolYear as SemesterSchool from Schedule
My current Error
Conversion failed when converting the varchar value 'F2UU ' to data type int.
1. How do I corret the spacing trim().
2. All I need to do is join these two collums into one
1. Cant change the original tables in the database
2. Boss is on me... any help?