Re: SQL Query Scalar Function Versus Second Table

First you need to check to see if there are valid duplicates in your 
master file.  For example is there both a part 'a-123' and a 'a1-23'?

select part# from pillai 
PART#
a-123
a1-23
*****

select replace(part#, '-', '') 
from pillai 
group by replace(part#, '-', '')
having count(*)>1 
....+....1
REPLACE 
a123 
******** 
select part# 
from pillai 
where replace(part#, '-', '') in 
 (select replace(part#, '-', '') 
  from pillai 
  group by replace(part#, '-', '')
  having count(*)>1) 
....+
PART#
a-123
a1-23
*****

If you get any hits - the project is doomed.



Rob Berendt