Database

Support123 wrote:

is there a way to select the values from the database as right aligned

declare @a char(20)<br />
set @a = 'testing'<br />
select right(space(20) + rtrim(@a), 20)

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.)

mavii wrote:

have applied the following query but in output one record appears repeatedly

Colin Angus Mackay wrote:

Interesting, and quite disappointing, that no one picked you up on the fact that your code is susceptable to a SQL Injection attack

Pete O`Hanlon wrote:

I would have thought that he'd want to make things as secure as possible beforehand.

Rocky# wrote:

progress-database-design-guide/[^]

CREATE TABLE tblScheduledInventory(
   asofDate           SMALLINT  -- number of days since Jan 1, 2000
 , partsGroupID       SMALLINT  -- REFERENCES tblPartsGroups
 , locationID         SMALLINT  -- REFERENCES tblLocations
 , statusCode         SMALLINT  -- "installed", "spare", etc.
 , inventoryTypeID    SMALLINT  -- "active", "in-reserve", etc.
 , CONSTRAINT pkScheduledInventory PRIMARY KEY 
             (asofDate,partsGroupID,locationID,statusCode,inventoryTypeID)
 , cnt                INT
);