asked
What is the % before the substring doing?
I am using SQL Server. I ran into the follow case statement but I don't understand the syntax of the % character in the following part ...a.WMS_Shipped_Qty%substring... What is that % sign doing between the 'Qty' and the 'substring'? Thank you. case when a.WMS_Shipped_Qty%substring(ED.casecode,patindex('[0-9]%',ED.casecode),len(ED.casecode))=0 then a.WMS_Shipped_Qty/substring(ED.casecode,patindex('%[0-9]%',ED.casecode),len(ED.casecode)) else a.WMS_Shipped_Qty end as 'WMS_Shipped_Qty' .....
It is the Modulo operator. It returns the remainder of one number divided by another.
https://msdn.microsoft.com/en-us/library/ms190279.aspx
17 People are following this question.
