Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Teki07
  • Content: Threads
  • Order by date
  1. Teki07

    Compare two columns within the same table

    Hi, I have a query that finds any duplicates caused by spacing. This is my query Select a.column1, b column1 from table1 as a, table1 as b where replace (a.column1,' ','') = replace (b.column1,' ','') and a.column1 <> b.column1 this is my result column1 column1_1 A+ A + A + A+ B+ B + B...

Part and Inventory Search

Back
Top