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