Hello

I am trying to mask data on a table, this table has 15 columns but no in all the columns has information, what I am trying to do its update the information if its no null but I haven have success, what I am trying its the follow (obiusly doesnt work).

DECLARE @i VARCHAR(15)
DECLARE @j VARCHAR(15)

SET @j = 'test'
SET @i = ''

UPDATE nodir
SET rfc = @i
WHERE isnull(name,SET @i = @j)

can you help me with this?

Regards

I don't understand your question - perhaps you should give some examples of what you want updated.

It's not by any chance as simple as this?
update <tablename>
set <columnname> = <value<
where <columnname> is null

Actually I finally resolved like this.

UPDATE nodir SET
CASE WHEN rfc = NULL THEN 0 ELSE 1 END 'test',


thank you