Removing Trailing Zeros

[john_denner]

Remove trailing zeros from decimal data types converted to text. Example usage: Concatenate text with a decimal number (S240306.0125000) should trim to S240306.0125) Using split with delimiter doesn't seem to always work without having to have many split by delimeters setup.