Forum Discussion

Copper Contributor

Oct 24, 2023

Is it a SSMS bug or am i doing it wrong?

declare @str varchar(20); set @str = '$200' SELECT CASE WHEN CHARINDEX(' ',@str,CHARINDEX('$',@str)+2) = 0 THEN 'aman' ELSE SUBSTRING(@str,CHARINDEX('$',@str),CHARINDEX(' ',@str,CHARINDEX('$',@str)...

Arshad440

Brass Contributor

Oct 25, 2023

Aman0712 This is not a SSMS bug as there is no syntax when using SUBSTRING() to give the length of characters(third parameter of substring()) in Negative Integer(-).It will cause an error.