Hi Lowell,

The data/column I need to update with the new value is actually in the same table "CustomerStorageInfo"

I need to do double string function to get the firmwarerevision value

Example data:...

Lowell,

thx for the advice, but still have issue with this.

SELECT * FROM #SampleTable WHERE ISNULL(VALUE,'') NOT IN('B')

==> That one did work and provided me the results as expected.

Sample data

TableA

machine_id model ...

That did the trick, I like these quick and dirty solutions 🙂

Thx again for all the help appreciated.

Hi thx for the quick feedback, the solution works for values that are 'NULL'. How about empty/blank columns?

Hi John,

thx for the quick response, that did the trick.

All,

thx for the info, now follow-up question, how would I do this via Update statement

I've tried following

UPDATE [invdb].[dbo].[puser]

SET [username] = (SELECT puser = case when a.username =...

Hi,

Thx for the quick reply and this indeed solved my issue. Really appreciated. Take care.