String Right justification
Hi, Can anyone tell me how right justification can be done in string Regards Nirmala __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
In esql there are procedures to manipulate strings that include this capability. In stored procedure you'll have to do it this way. <<<< pseudo code >>>> rightJustify(string str,int width) let spaces=" " ; //spaces has 255 spaces or what ever the max width will be. let len = length(str); if (len >= width) { let ret = str; } else { let ret = substr(spaces,1,width - length) || str ; } return ret; Nirmala Kesavan wrote: > Hi, > Can anyone tell me how right justification can be done in string > > > Regards > Nirmala > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > --0-24551121-1149746772=:46256 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > X-Google-AttachSize: 348 > > <div>Hi,</div> <div> Can anyone tell me how right justification can be done in string</div> <div> </div> <div> </div> <div>Regards</div> <div>Nirmala </div><p> __________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com > --0-24551121-1149746772=:46256--