RE: equivalent of LPAD in Transact SQL

From: YTTRI Lisa <lisa.yttri_at_cnh.com>
Date: Thu, 25 Oct 2001 06:37:17 -0700
Message-ID: <F001.003B4307.20011025064024@fatcity.com>

I
believe you would use the 'stuff' command.

<FONT face=Tahoma

  size=2>-----Original Message-----From: Suhen Pather   [mailto:Suhen.Pather_at_strandbags.com.au]Sent: Wednesday, October 24,   2001 9:55 PMTo: Multiple recipients of list   ORACLE-LSubject: equivalent of LPAD in Transact   SQL
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">List,
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Bit of an inappropriate question   to the Oracle List.
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Does anybody know the SQL Server   (Transact SQL) equivalent of the LPAD <SPAN   class=GramE>function.
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Regards
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Suhen
<SPAN

  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> Received on Thu Oct 25 2001 - 08:37:17 CDT