HI
I am some difficult on updating my rows on my databases in sql server 2005 , i am searching but i am not yet found .
if someone know a function or script who help to update : on updating i want to add 1 on each rows
egs : 1 3 CCh4 after update 11 31 CCh41
66 99 VBj6 after update 661 991 VBj61
thanks

could you please script out your table definition, i.e. column names and datatypes

there is my table definition :
table name : note(mat(numeric),cod(varchar),ref(varchar))

no you don't understand me , i want to update on adding to last position
on field the element 1 and no increasing 1

mhmdsw,

Test-out r937's suggested solution.

I think you will find that it does exactly what you want.

just adding 1 for each rows
egs : if i two rows :
12 tt1 bby after update 121 tt11 bby1
6 vv6 nnh after update 61 vv61 nnh1

just add the element on last position to the field

try my update statement, please

IF you means 1 become 11 and asd become asd1 and qwe become qwe1
the posted solution will solve your problem, first he manipulate the integer number by add place for your new number 1 = 1 * 10 + 1 = 11 right?
and cod = co + '1' (+) is a concatenation operator so asd = asd + '1' = asd1
try it.

IF you means 1 become 11 and asd become asd1 and qwe become qwe1
the posted solution will solve your problem, first he manipulate the integer number by add place for your new number 1 = 1 * 10 + 1 = 11 right?
and cod = co + '1' (+) is a concatenation operator so asd = asd + '1' = asd1
try it.


Elmozamil

Try also the SQL2005 documentation :

1) Learn more about string (char, varchar, ...) concatenation
+ (String Concatenation) (Transact-SQL)
2) Learn more about arithmetic operator :
* (Multiply) (Transact-SQL)
Multiplying by 10 in the decimal world is just as multiply by 2 (decimal) or 10 (binary) in the binary world : just shift all digits 1 position left and put the 0 in the most right open position. After that you add 1 to the numeric value and the 0 in most right position will become a 1.

Just what u want, or not ?
if not give us an example that not match !!