sql-programmers (1/1/2014)
Thanks for your response..I need little more specific..
Business logic is I need to export all values from a table without any duplication. I considered Test. Test.. are the duplicates.
The value is "Test." not "2.Test."
Then your SELECT DISTINCT will do fine.
--Jeff Moden
Change is inevitable... Change for the better is not.