remove trailing zeros

[rrmcguire]

I have a formula

CONCAT('0','order_id') and when I run this is adding the zero to the beginning of order_id but is also adding 15 trailing zeros...is there any way to remove these?

thanks

 

[Olaf Doschke]

In MSSQL this will result in [tt]0order_id[/tt].

You don't use MS SQL Server, you're in the wrong forum. SQL dialects differ.
Let's see, what you are using. What is the result of

Select @@Version

Error?

Bye, Olaf.