can someone tell me a sql formula to use in a Sales Order container to drop the leading zeros.
I need to match / index to files where the sales order number is entered without the leading zeros.
REPLACE(LTRIM(REPLACE(SO_SalesOrderHeader.SalesOrderNo, '0', ' ')), ' ', '0')
That's It!!! Thank You:)
*Community Hub is the new name for Sage City