How to update status to not match character in case of signature key not have stars *?

[yosiasz]

I am starting to think you might be a bot. habibi you are going to have to start showing some initiative and some hard work.

How to update status based on positional value of another column

using @JeffModen DelimitedSplit8K use sqlteam go create table #Ref ( SignatureKey nvarchar(50), GroupId int, PortionKey nvarchar(50), Status nvarchar(100) ) insert into #Ref(SignatureKey,GroupId,PortionKey,status) values ('*$*$**$***$**$**$*',3,'s',NUll), ('*$*$*$***$*$**$*',4,'s2',NUll), ('*$*$*$***$*$**$*',6,'shd',NUll), ('*$**$*$***$***$**$*',2,'g',NUll), ('*$**$*$***$**$**$*',5,'f',NUll), ('*$*$*******$*$**$**$*',7,'f',NUll) --test extra to see accuracy 7 ;with jazz as ( select * Fro…