SQL Code question | Forum

2014-12-05 10:30:40

Hi all,
We are a 6.07 site,
I am trying to basically get part of a string:
This is the starting string:
Ex. G0-20120402180416698-1...the issu
I want the characters in yellow.

SUBSTRING(OrderId,11,len(RX.OrderId)-2)
I cannot get the len function to work in the substring function. My thinking is that the len function should return a number. That should statisfy the 3rd requirement if the substring function.
What happens is it just selects all the "OrderId" characters past the 11th postion.(this includes the -1...which I am ultimately trying to get rid of).
Any thoughts would be great!
Thanks,
Mark
PRIVACY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and the information is
confidential, privileged or protected by law. Any unauthorized review,
use, disclosure, copying, or distribution to anyone other than the specific
person or office addressed is strictly prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message and attachments.