mitchem1
Registered User.
- Local time
- Today, 16:53
- Joined
- Feb 21, 2002
- Messages
- 153
A field in one of our users' tables has odd entries such as:
1152+10
22+94
15+532
28+83
3+722
1084+75
and so on. The number of characters on either side of the + sign can always vary.
The problem is that in reports, the user wants all of the + signs perfectly aligned. Obiously, justifying the column right, left, or centered will not achieve this. Is there a brilliant way to do this, short of separating the column into multiple columns? If not, what kind of queries would one use to separate this data? Thanks.
1152+10
22+94
15+532
28+83
3+722
1084+75
and so on. The number of characters on either side of the + sign can always vary.
The problem is that in reports, the user wants all of the + signs perfectly aligned. Obiously, justifying the column right, left, or centered will not achieve this. Is there a brilliant way to do this, short of separating the column into multiple columns? If not, what kind of queries would one use to separate this data? Thanks.