I'm having one of those days. I really couldn't see the wood for the
trees. I have taken yours and Adams suggestions and applied the
changes to my development database. After a couple of tweaks to the
code and hey presto, it's working like a charm.

Cheers guys!!

> Why not just write one stored procedure, GET_COMPANIES, and pass to

it the

> type of search you want, followed by the search argument? If the

arguments

> are of different variable types, cast them in the procedure

accordingly, but

> pass them in as strings?
>
> Then there is no need to worry about the WHERE clause in your SP

(unless you

> specifically want to do this).
>
> Myles