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' .....
asked Jan 09 at 04:06 AM in Default
It is the Modulo operator. It returns the remainder of one number divided by another.
answered Jan 09 at 09:23 AM