Allan
asked on
Permutation of Zeros
Hi Experts !
How do you select a string field for those only
with a permutation of Zeros?
You want to ignore (not select) if there are other values:
For example:
field01
-------
1. 0000
2. 00100
3. 0000000
4. 0
5. 00012s0
7. 000
8. 00
9. 10
10. 00000e1
11. 4c00000
select * from tbl01
where ???
so the return values should be:
1. 0000
3. 0000000
4. 0
7. 000
8. 00
Thanks in advance for your help.
How do you select a string field for those only
with a permutation of Zeros?
You want to ignore (not select) if there are other values:
For example:
field01
-------
1. 0000
2. 00100
3. 0000000
4. 0
5. 00012s0
7. 000
8. 00
9. 10
10. 00000e1
11. 4c00000
select * from tbl01
where ???
so the return values should be:
1. 0000
3. 0000000
4. 0
7. 000
8. 00
Thanks in advance for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks ScottPletcher -- haven't seen that before. Thanks for sharing.
I'll try it and let you guys know.