How to pad with leading zeros an int or smallint in sybase?
Answer / Majid Ali Khan
To pad an INT or SMALLINT column with leading zeros in Sybase, you can use the RIGHT() and LPAD() functions.nFor example:nnCREATE TABLE MyTable (MyCol INT);nINSERT INTO MyTable VALUES (123);nUPDATE MyTable SET MyCol = RIGHT('000' + CAST(MyCol AS VARCHAR), 4);
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the architechure of sybase ASE?
What is cis and how can I use it?
List different types of locks in sybase?
How do you use workspace in sybase?
What is asa ultralite in sybase?
How does sybase replication work?
What is sybase infomaker?
How do you check database space?
What is isql in sybase?
In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?
can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com
Explain about the features of sybase iq?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)