I need to run a query to extract car manuafactuers from a list of companies. The trouble is that there can be a number of versions

e.g. AUDI can be AUDIO, CLAUDIO etc so I can't used CONTAINS or INDEXC

Any suggestion as to how I can do this.

Use proc sql and use LIKE clause