Hello everyone,

I'm new here. I have a question for the function posted above and wish anyone can give me an answer.

I used the above function to create a new function in VBA and used it in a SELECT query and it works. But unfortunately it only returns up to 255 characters.

Does anyone know how to return more than 255 characters using this function or is there any new function to do this please?

Thank you very much for your help.