remove trailing zeros remove trailing zeros rrmcguire (Programmer) (OP) 14 Jun 16 19:27 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 RE: remove trailing zeros Olaf Doschke (Programmer) 15 Jun 16 04:16 In MSSQL this will result in 0order_id. 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 CODE --> T-SQLSelect @@Version Error? Bye, Olaf.