G
Guest
I have fields that might look like this:
100106
98742306
9806
I always want to remove the "06" at the end. I'd like my result to look
like this:
1001
987423
98
I've been trying to using RTRIM without any luck. I am looking for a
solution that can be done as an expression.
Thanks!
100106
98742306
9806
I always want to remove the "06" at the end. I'd like my result to look
like this:
1001
987423
98
I've been trying to using RTRIM without any luck. I am looking for a
solution that can be done as an expression.
Thanks!