Sqlserver padleft, padright

You need to customize the function,CodeAs follows:

 Code

Create   Function Padleft ( @ Originalstring   Varchar ( 20 ), @ Paddingchar   Char ( 1 ), @ Totallength   Int )
Returns   Varchar ( 20 ) As
Begin
Declare   @ Newstring   Varchar ( 20 )
Select   @ Newstring   =   Isnull ( Replicate ( @ Paddingchar , @ Totallength   -   Len ( Isnull ( @ Originalstring , 0 ))), '' ) +   @ Originalstring
Return   @ Newstring
End

Create   Function Padright ( @ Originalstring   Varchar ( 20 ), @ Paddingchar   Char ( 1 ), @ Totallength   Int )
Returns   Varchar ( 20 ) As
Begin
Declare   @ Newstring   Varchar ( 20 )
Select   @ Newstring   =   @ Originalstring   +   Isnull ( Replicate ( @ Paddingchar , @ Totallength   -   Len ( Isnull ( @ Originalstring , 0 ))), '' )
Return   @ Newstring
End

 

Do not forget the DBO prefix.

Select DBO. padleft ( ' 101 ' , ' 0 ' , 6 ) -- 002008
Select DBO. padright ( ' 101 ' , ' 0 ' , 6 ) -- 200800