Brogrim
asked on
left function and append
I have changed the value from 6 - 7,
Former W71234 has become W712340 instead of W071234
What query would put the 0 in front of the W instaed of at the end?left function and append
Former W71234 has become W712340 instead of W071234
What query would put the 0 in front of the W instaed of at the end?left function and append
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Brogrim,
Looks like you did not see my post....
Looks like you did not see my post....
set fld1=Left([fld1],1) & "0" & mid([fld1],2)