René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"TRIM with FROM clause in RETURN statement fails to parse","articleBody":"## Summary\n\nScriptDom fails to parse valid T-SQL when `TRIM` function with `FROM` clause is used inside a `RETURN` statement. The same syntax parses correctly in `SELECT` or `SET` statements.\n\n## Version\n\nMicrosoft.SqlServer.TransactSql.ScriptDom: 170.157.0\n\n## Steps to Reproduce\n\nParse the following valid T-SQL:\n\n```sql\nCREATE FUNCTION dbo.TrimTest(@str NVARCHAR(MAX))\nRETURNS NVARCHAR(MAX)\nAS\nBEGIN\n    RETURN TRIM('x' FROM @str);\nEND\n```\n\n## Expected Result\n\nThe SQL should parse successfully, as it is valid T-SQL syntax that executes correctly on SQL Server.\n\n## Actual Result\n\nParse error: `Incorrect syntax near 'TRIM'.`\n\n## Error Messages\n\n```\nLine 5, Column 12: Incorrect syntax near 'TRIM'.\n```\n\n## Additional Information\n\nThis issue affects all `TRIM` variations using the `FROM` clause inside a `RETURN` statement:\n\n| Case | RETURN | SELECT / SET |\n|------|--------|--------------|\n| `TRIM(@str)` | OK | OK |\n| `TRIM('x' FROM @str)` | FAIL | OK |\n| `TRIM(NCHAR(12288) FROM @str)` | FAIL | OK |\n| `TRIM(LEADING ... FROM @str)` | FAIL | OK |\n| `TRIM(TRAILING ... FROM @str)` | FAIL | OK |\n| `TRIM(BOTH ... FROM @str)` | FAIL | OK |\n\n### Workaround\n\nUsing a variable as an intermediate step parses successfully:\n\n```sql\nCREATE FUNCTION dbo.TrimTest(@str NVARCHAR(MAX))\nRETURNS NVARCHAR(MAX)\nAS\nBEGIN\n    DECLARE @result NVARCHAR(MAX);\n    SET @result = TRIM('x' FROM @str);\n    RETURN @result;\nEND\n```\n\n### Minimal Reproduction Code\n\n```csharp\nusing Microsoft.SqlServer.TransactSql.ScriptDom;\n\nvar sql = \"\"\"\n    CREATE FUNCTION dbo.Test(@str NVARCHAR(MAX))\n    RETURNS NVARCHAR(MAX)\n    AS\n    BEGIN\n        RETURN TRIM('x' FROM @str);\n    END\n    \"\"\";\n\nvar parser = new TSql170Parser(initialQuotedIdentifiers: false);\nusing var reader = new StringReader(sql);\nparser.Parse(reader, out var errors);\n\nforeach (var e in errors)\n    Console.WriteLine($\"Line {e.Line}, Col {e.Column}: {e.Message}\");\n```\n\nTested with both TSql160Parser and TSql170Parser - same result.\n","author":{"url":"https://github.com/masmgr","@type":"Person","name":"masmgr"},"datePublished":"2026-02-03T04:07:14.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/188/SqlScriptDOM/issues/188"}