> The question is when I do > OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, > 'DM')-1 I get 1 not 01. > Why? And how do I get these to match?
In the first expression, 02 is a string. You are then applying an arithmetic operation, which coerces it into a number (1). To get them to match, either format the second number (01) or add zero to the first to coerce it (2). Brian ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
