RE: equivalent of LPAD in Transact SQL

[YTTRI Lisa]

I believe you would use the 'stuff' command. -----Original Message----- From: Suhen Pather [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 9:55 PM To: Multiple recipients of list ORACLE-L Subject: equivalent of LPAD in Transact SQL List,   Bit of an inappropriate question to the Oracle List.   Does anybody know the SQL Server (Transact SQL) equivalent of the LPAD function.   Regards Suhen