Oracle function LPAD to MSSQL

[kallikru]

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).]

[kallikru]

^bump^

------------------
Karl, Denmark
---------
"..and may The Force be with you - too..."

[rooney7amba]

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