Database

SELECT YourStudentNumberColumn AS [Test],<br />
		'01' + SUBSTRING(YourStudentNumberColumn,3,LEN(YourStudentNumber) - 2) AS [TestAfterUpdate]

UPDATE YourTableName<br />
SET YourStudentNumberColumnName = '01' + SUBSTRING(YourStudentNumberColumnName,3,LEN(YourStudentNumber) - 2) 

dandamudi padma wrote:

if a new row is added in table1

mehrdadc48 wrote:

How can I transfer a DB from SQL Server 2005 to 2000 completely(with all tables, diagrams, stored procedures and ...)

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.