Effectively. The usefulness of this function is not that of rapid execution, but the utility of the result. That is why there is a key that lists the results and...

I apologize again. He was indeed in the clouds and did not think what he wrote.

I don't usually use char or nchar except in some very specific cases.

Sorry, I was wrong in my explanation. I don't use varchar because in my work there are data in several languages, and I use nvarchar, not varchar.

I am intelligent and I have no varchar of 1 billion characters.

Also, in my designs, there is usually no place for varchar. In that case, I would use text strings...

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [ibb].[StringToTableStrings]
(
  @cadena NVARCHAR(MAX),
  @separador NVARCHAR(MAX) = ',',
  @eliminarNulos BIT = 1,
  @trim BIT = 1
) RETURNS @tabla...

I reiterate my apologies for my English. I use google translate and I am sorry for not knowing the meaning of certain words.

This contibución 've done with the intention to...

I 'm sorry for my english

I understand your distrust. It's just a suggestion intended to help. You simply can test and if it is found that works and helps, as...

I do not speak English, so I use google translate .

I have developed a tool that does what you want , but help is in Spanish ( README InsertBulkBestia.txt )...