Sum statement involving a varchar column
Within the database I am working in, the column Notes is datatype varchar with a date value and a note placed right after (Example: 05/15/2024: This is the note.) There are two main comments I have extracted into another column using a Case When expression which is as follows:
Sum statement involving a varchar column
Within the database I am working in, the column Notes is datatype varchar with a date value and a note placed right after (Example: 05/15/2024: This is the note.) There are two main comments I have extracted into another column using a Case When expression which is as follows: