right align
-
Hi, Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to
char()datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using theREPLACE(TheRecordFromTheTable, ' ',''), this will help to remove the added spaces from the back due tochar()datatype.) Thank you in advance..."Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
-
Hi, Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to
char()datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using theREPLACE(TheRecordFromTheTable, ' ',''), this will help to remove the added spaces from the back due tochar()datatype.) Thank you in advance..."Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
hi plz clarify your question... Regards Joe
-
Hi, Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to
char()datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using theREPLACE(TheRecordFromTheTable, ' ',''), this will help to remove the added spaces from the back due tochar()datatype.) Thank you in advance..."Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
-
Hi, Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to
char()datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using theREPLACE(TheRecordFromTheTable, ' ',''), this will help to remove the added spaces from the back due tochar()datatype.) Thank you in advance..."Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
-
Hi, Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to
char()datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using theREPLACE(TheRecordFromTheTable, ' ',''), this will help to remove the added spaces from the back due tochar()datatype.) Thank you in advance..."Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Support123 wrote:
Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to char() datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using the REPLACE(TheRecordFromTheTable, ' ','') , this will help to remove the added spaces from the back due to char() datatype.)
Is there a particular reason why you are storing numbers as strings? Wouldn't storing numbers as binary fields be more efficient?
-
Support123 wrote:
Can you set a column to store data right aligned? (the reason i want to know this is because all our values are set to char() datatype in SQL database. This will mean that the left out characters / the character that are short will be filled in with blank spaces. Having the value right aligned will mean that the spaces will be put in front of the value and not at the back and that is what i am looking for (if this is possible).) OR is there a way to select the values from the database as right aligned (i will be using the REPLACE(TheRecordFromTheTable, ' ','') , this will help to remove the added spaces from the back due to char() datatype.)
Is there a particular reason why you are storing numbers as strings? Wouldn't storing numbers as binary fields be more efficient?
Thank all of you... BUT never mind... i found a way around my problem... sorry for stating my question so unclear. I wasn't even sure what i needed. What i wanted to do is add the spaces in front of some of the Values in the database. This is then easier when i have to populate the flatfile using ssis package. (The reason why i store the numbers as CHAR() is just a staging table. Easier to get the fixed length right :) ) Thank you all once again for the effort.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison