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.
select 'A ' from dual -- A with trailing space union select 'A' from dual -- A without trailing space Result: A A
select 'A ' -- A with trailing space union select 'A' -- A without trailing space Result: A
As you can see Oracle treats 'A ' and 'A' as two distinctive values where MS Sql servers treats them as equal.
Quit a differnce.