DECLARE @userId bigint;
SELECT @userId = 740;
While(@userId <= 890)
begin

  DECLARE @indexOfDash bigint;
  SELECT @indexOfDash = (SELECT CHARINDEX(' - ', [FullName]) FROM [TestDB].[dbo].[Client] WHERE ID = @userId) + 1;
  print @indexOfDash
  DECLARE @fullName varchar(max);
  SELECT @fullName = (SELECT LTRIM(SUBSTRING([FullName], @indexOfDash, LEN([FullName]))) FROM [TestDB].[dbo].[Client]  WHERE ID = @userId);

  DECLARE @replacedFullName varchar(max);
  SELECT @replacedFullName = LTRIM(
                                REPLACE(
                                    REPLACE(
                                        REPLACE(
                                            REPLACE(
                                                REPLACE(UPPER(@fullName),'ФОП',''),
                                                'ТОВ', ''),
                                            'ПП',''),
                                        '-', ''),
                                    'Предоплата',''));
  DECLARE @name varchar(max)
  IF (SELECT CHARINDEX('"', @replacedFullName)) != 0
    BEGIN
        DECLARE @firstQuote varchar(max);
        SELECT @firstQuote = (SELECT SUBSTRING(@replacedFullName, CHARINDEX('"', @replacedFullName) + 1, len(@replacedFullName)));

        SELECT SUBSTRING(@firstQuote, 1,1);
    END
  ELSE
      BEGIN
      WITH ClientFullName AS
      (
            SELECT value,
            ROW_NUMBER() OVER(ORDER BY CURRENT_TIMESTAMP) AS 'RowNumber'
            FROM STRING_SPLIT(@replacedFullName, ' ')
      )
      SELECT CONCAT(
            SUBSTRING((SELECT value FROM ClientFullName WHERE RowNumber = 1), 1, 1),
            SUBSTRING((SELECT value FROM ClientFullName WHERE RowNumber = 2), 1, 1)
        )
      END


  SET @userId = @userId +1
END