Boultonsj wrote ...

Used single & double quotes but still failed. For those NI codes that work
using quotes caused them to fail. Thanks anyway.

What is the data type? Is there a pattern to the codes that fail e.g.
leading zeros, more than 16 digits, etc? Do they work if you hard code
them in the sql text?

Jamie.

--