Link to home
Start Free TrialLog in
Avatar of Allan
AllanFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allan

ASKER

Thanks angelIII -- why didn't I think of that. Good idea.
Thanks ScottPletcher -- haven't seen that before. Thanks for sharing.

I'll try it and let you guys know.

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial