Hi All,
could you please help me to get the below expected outputs:
If
FixBy='QR9-02-Feb' o/p:902
FixBy='QR10-04-Apr' o/p:1004
FixBy='TextData' o/p:100
SELECT (CASE WHEN isnumeric(substring([FixBy], 3, 1)) = 1 THEN substring([FixBy], 3, 1) ELSE '1' END) +
(CASE WHEN isnumeric(substring([FixBy], 5, 2)) = 1 THEN substring([FixBy], 5, 2) ELSE '00' END) AS sprint,
For FixBy='QR9-02-Feb' and FixBy='TextData' above query is working as expected by facing issue at FixBy='QR10-04-Apr'
while passing FixBy='QR10-04-Apr' its returning as 1-0
Thanks in advance.
Naseer