Text Trimmed Automatically
I would like to know if text is somehow trimmed by Yellowfin or is it my vendor? When I type the below SQL my report "fixes" the formatting so that there is one space between characters:
SELECT DISTINCT '1 2 3 4',Produces:
For example, I created a CASE statement based on what the report was displaying and that was 'Unknown - discharged due to inactivity' but in the database field it was actually stored as 'Unknown - discharged due to inactivity'. Notice the additional space between '-' and 'discharged'.