Printable View
Anyone know how to convert the (Oracle8) function LPAD (left-padding a field with specific characters) to MS SQL (7.0)?
MSN says "N/A" to LPAD/RPAD when comparing functions.
------------------
Karl, Denmark
---------
"..and may The Force be with you - too..."
[This message has been edited by kallikru (edited 08-17-2001).]
^bump^
------------------
Karl, Denmark
---------
"..and may The Force be with you - too..."
using LPAD :
-----------
table users
-----------------|
|id | name |
|--------------- |
| 1 |liwa ganteng |
---------------- |
example oralce : select lpad(id,5,0), name from users
result : 00001 | liwa ganteng
example Ms SQL : select replicate(0,5-len(id))+id, name from users
result : 00001 | liwa ganteng
using RPAD :
-----------
example oralce : select rpad(id,5,0), name from users
result : 10000 | liwa ganteng
example Ms SQL : select id+replicate(0,5-len(id)), name from users
result : 10000 | liwa ganteng