From: Rich on
Thanks. This sort of works. I will have to experiment with it a little bit
to get it to isolate all the rows I need. It does isolate a few of the rows.


"Plamen Ratchev" wrote:

> Try:
>
> SELECT <columns>
> FROM A
> JOIN B
> ON A.company LIKE B.company + '%';
>
> --
> Plamen Ratchev
> http://www.SQLStudio.com
> .
>