[thelist] Quick SQL help...

Jay Blanchard jblanchard at pocket.com
Wed Aug 30 17:13:37 CDT 2006


[snip]

Take this list of SKU's:

ABC123

EPSABC123

EE442

DFE332

EPSDFE332


Is there an easy way to find a list of SKU's that remotely match another
one in the list? The sample result might look like:

 

SKU             Match

ABC123      EPSABC123

DFE332       EPSDFE332
[/snip]
 
Pseudo-query;

select a.sku, b.sku from a.table, b.table (table is the same) where
a.sku LIKE b.sku



More information about the thelist mailing list