Some string error in function, object no defined.

[hellind]

I have attached a strip down database. Try to query [query_dt_volume1]

It is simple query, calling the function in module: CustomSplit.

I want Output should be:
<blank> = <blank>
<blank> = <blank>
Tower Records [USA] = Tower Records
Deutsche Bank [Hong Kong] = Deutsche Bank


HongKong Fund = HongKong Fund


Why am I getting the error in this function: CustomSplit

I have commented the code, if you have your code it will be great too. I went for the SPLIT function because it is simple. Seems like the error happens in the first two records where the entity is blank. Tried all variations of checking.

[RuralGuy]

Try this one that uses the Nz() function.

[hellind]

Thank you very much. It worked.

For the first two records, without using NZ(), was an empty string been passed over? What is happening?

[RuralGuy]

It was probably a Null rather than an empty string.