Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Appending the value with NULL value

2 Posts 2 Posters 0 Views 1 Watching

R Offline
R Offline
Revathij

wrote on last edited by

#1

hi all, I want to append the value '123' with the value in column A. Column A is having few NULL value rows. NUll values should be replaced by the new value and others should be appended. How to do this in all rows of column A? Thanks in advance
J 1 Reply Last reply

0
R Revathij

hi all, I want to append the value '123' with the value in column A. Column A is having few NULL value rows. NUll values should be replaced by the new value and others should be appended. How to do this in all rows of column A? Thanks in advance
J Offline
J Offline
J4amieC

wrote on last edited by

#2

Gosh you really need to pick up a basic book on SQL!

UPDATE myTable
SET myColumn = ISNULL(myColumn,'') + 'abc'
1 Reply Last reply

0

Log in to reply