TrimStart and TrimEnd with optional char array implementation for SQL Server

[abdielcs]

Fixes #22924

• [X ] I've read the guidelines for contributing and seen the walkthrough
• [ ] I've posted a comment on an issue with a detailed description of how I am planning to contribute and got approval from a member of the team
• [ X] The code builds and tests pass locally (also verified by our automated build checks)
• [X ] Commit messages follow this format:

        Summary of the changes
        - Detail 1
        - Detail 2

        Fixes #bugnumber

• [X ] Tests for the changes have been added (for bug fixes / features)
• [X ] Code follows the same patterns and style as existing code in this repo