Hi Phil Parkin,

Yes some rows my device names doesnt have the underscore.

Could you please provide an alternate to ignore these

Hi Phil Parkin,

This is working on the sample data I created.

But If I apllied on my original table I am getting below error.

Invalid length parameter passed to the LEFT...

Hi ,

I have added the insert update code in main question