How to add leading zeros in sybase ase

sybase sap-ase
max picture max · Mar 23, 2016 · Viewed 8.3k times · Source

Need to add leading zeros to column values(varchar) and update it in same table. ex: 431 as 000431, 5431 as 005431, 64531 as 064531, basically i need to substitute zeros to the data so that it is 6 digits. this is in sybase ase.

thanks

Answer

maf-soft picture maf-soft · Mar 30, 2017

If you can't use LPAD(), and the source number is an integer, this solution is maybe a little nicer than yours:

RIGHT(1000000+Number, 6)

But, as yours, it produces unexpected results if the value is negative or has more than 6 digits.

Related questions

From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.

Read More
list all tables from a database in syBase

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do the same in syBase ?

Read More
How do I look at column metadata in Sybase?

I have a list of columns a co-worker has given to me, but these columns reside in different tables in the DB. Is there some kind of tool in Sybase where I can query the table a column belongs to? (…

Read More