In datprof Integrate I have some Union queries where the data my or may not contain traling spaces.
I know that the Union statement removes duplicates from the result.
Given this base query:
Select 'A '
Do Oracle and Microsoft treat this the same?
Consider the code below.
As you can see Oracle treats 'A ' and 'A' as two distinctive values where MS Sql servers treats them as equal.
Quit a differnce.