Как решить проблему с пространством в таблице ошибок SQL?

Question

https://stackru.com/i mage s/3528c4adf8756859daf0ff99365fc58f0822f507.png

Я делаю запрос на сервере SQL, который помогает мне удалить пробелы в столбце (Name_Arabic), но это не помогло мне, и я использую другой запрос, чтобы разделить столбец, могу ли я решить эту проблему в этом запросе???

мой код для разделения столбца

SELECT        Name_Arabic,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_10
                            WHERE        (Ordinal = 1)) AS Col1,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_9
                            WHERE        (Ordinal = 2)) AS Col2,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_8
                            WHERE        (Ordinal = 3)) AS Col3,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_7
                            WHERE        (Ordinal = 4)) AS Col4,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_6
                            WHERE        (Ordinal = 5)) AS Col5,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_5
                            WHERE        (Ordinal = 6)) AS Col6,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_4
                            WHERE        (Ordinal = 7)) AS Col7,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_3
                            WHERE        (Ordinal = 8)) AS Col8,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_2
                            WHERE        (Ordinal = 9)) AS Col9,
                         (SELECT        Part
                            FROM            dbo.CustomStringSplit(dbo._2.Name_Arabic, ' ') AS CustomStringSplit_1
                            WHERE        (Ordinal = 10)) AS Col10

Answer 1

Кто -нибудь, помогите мне с этим ответом, я надеюсь, что это поможет любому Элю, ищущему что-то подобное

UPDATE yourtable SET Name_Arabic = LTRIM(Name_Arabic)