News

select substring(convert(varchar,day_id,120),1,10) rawdate, (case when min(execduration) = -1 then 1 else min(execduration) end)/1000 mymin, max(execduration)/1000 ...
After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server ... SUBSTRING(@Data, @HandledLength + 1, @NextPart ) SELECT @OldChunk = CONVERT(VARBINARY(8000 ...
From what I've been able to gather, using REGEXP_SUBSTR could be a way to go, but I just don't know Regular expressions well enough to do anything useful.