We would like to link an order # which is 8 characters with the 'original order number' which is also 8 but unfortunately is stored in a 24 char column and you can get it this way> ReplicateString ("0",8-LENGTH(TRIM(MID({OEORH41.OHPO#},1,8))) )&TRIM(MID({OEORH41.OHPO#},1,8))
On the database expert linking is there any way to provide this trim function so we can link correctly?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.