<div>
Do you want the database to prepend blanks in order to right-justify? &nbsp;Or is this a question about how to make the application display data differently?<br />
<br />
Greg
</div>


Do you want the database to prepend blanks in order to right-justify?  Or is this a question about how to make the application display data differently?

Greg

<div>
I guess you need a + operator ..<br />
<br />
select left((space(15) + convert(varchar, myField)),15) from tablename
</div>


I guess you need a + operator ..

select left((space(15) + convert(varchar, myField)),15) from tablename

<div>
<div class="content wysiwyg-content">
I want to know that how can we right / left justify a text field for example if we have char/varchar field of width 15 and only 4 chars exists in table so when we use select fielname from tablename then fieldname must be right justifies with blank padded at its left side.<br />
<br />
It should look like following<br />
fieldname<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxxx<br />

</div>
</div>


I want to know that how can we right / left justify a text field for example if we have char/varchar field of width 15 and only 4 chars exists in table so when we use select fielname from tablename then fieldname must be right justifies with blank padded at its left side.

It should look like following
fieldname
           xxxx


Right/ Left Justify

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.