Thank this author by sharing:
By Nagabhushanam Ponnapalli,
RPAD returns char1, right-padded to length n with char2, replicated as many times as necessary; char2 defaults to a single blank. If char1 is longer than n, this function <BR>returns the portion of char1 that fits in n. <BR>The argument n is the total length of the return value as it is displayed on your terminal screen. In most character sets, this is also the number of characters in the return value.
LPAD returns char1, left-padded to length n with the sequence of Chars in char2;
Procedure return value problem
decryptbycert returns null
Function Returning Table
Does RETURN abort, or does it return a value?
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.