Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Adding Leading Zeros
Hello- I want to add leading zeros to a varchar field with length of 13. The following is the generally accepted syntax Select right('0000000000000' + PROD_ID, 13) FROM PRODUCTS The error I am getting is: [SELECT - 0 row(s), 0.000 secs] [Error Code: 0, SQL State: 42725] ERROR: operator is not unique: "unknown" + varchar Which is not helpful. Can anyone please help?