RE: Re: [Q] Select Problem

--openmail-part-000c1e32-00000001 Content-Type: multipart/alternative; boundary=openmail-part-000c1e32-00000002 --openmail-part-000c1e32-00000002 Content-Type: text/plain; charset=ISO-8859-1; name="BDY.RTF" Content-Disposition: inline; filename="BDY.RTF" Content-Transfer-Encoding: quoted-printable I'm not sure if my last message was sent properly, so here it is again........ =2E........................................ Oops, The last message I sent had a small problem in the select........ It didn't work!!!!!!! It only picked up numbers that divded equally between 100, 1000 etc... Below is a select that WILL work (I promise) SELECT acc_no = =20 FROM pers = =20 WHERE acc_no =3D 2 = =20 OR trunc(acc_no/10,0)=3D2 = =20 OR trunc(acc_no/100,0)=3D2 = =20 OR trunc(acc_no/1000,0)=3D2 = =20 OR trunc(acc_no/10000,0)=3D2 = =20 OR trunc(acc_no/100000,0)=3D2 = =20 OR trunc(acc_no/1000000,0)=3D2 = =20 OR trunc(acc_no/10000000,0)=3D2 = =20 OR trunc(acc_no/100000000,0)=3D2 = =20 OR trunc(acc_no/1000000000,0)=3D2 =20 =20 If at first you don't succeed...... Forget it!!!!! Jamie =20 --openmail-part-000c1e32-00000002 Content-Type: application/rtf; name="BDY.RTF" Content-Disposition: attachment; filename="BDY.RTF" Content-Transfer-Encoding: base64 e1xydGYxXGFuc2lcZGVmZjBcZGVmdGFiNzIwe1xmb250dGJse1xmMFxmc3dpc3MgTVMgU2Fu cyBTZXJpZjt9e1xmMVxmcm9tYW5cZmNoYXJzZXQyIFN5bWJvbDt9e1xmMlxmc3dpc3MgQXJp YWw7fXtcZjNcZnN3aXNzIEFyaWFsO319DQp7XGNvbG9ydGJsXHJlZDBcZ3JlZW4wXGJsdWUw O1xyZWQwXGdyZWVuMFxibHVlMjU1O30NClxkZWZsYW5nMjA1N1xwYXJkXHBsYWluXGYyXGZz MjBcY2YxIEknbSBub3Qgc3VyZSBpZiBteSBsYXN0IG1lc3NhZ2Ugd2FzIHNlbnQgcHJvcGVy bHksIHNvIGhlcmUgaXQgaXMgYWdhaW4uLi4uLi4uLg0KXHBhciANClxwYXIgLi4uLi4uLi4u Li4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4NClxwYXIgDQpccGFyIFxwbGFpblxm M1xmczIwXGNmMVxwcm90ZWN0IE9vcHMsDQpccGFyIA0KXHBhciBUaGUgbGFzdCBtZXNzYWdl IEkgc2VudCBoYWQgYSBzbWFsbCBwcm9ibGVtIGluIHRoZSBzZWxlY3QuLi4uLi4uLg0KXHBh ciBJdCBkaWRuJ3Qgd29yayEhISEhISENClxwYXIgDQpccGFyIEl0IG9ubHkgcGlja2VkIHVw IG51bWJlcnMgdGhhdCBkaXZkZWQgZXF1YWxseSBiZXR3ZWVuIDEwMCwgMTAwMCBldGMuLi4N ClxwYXIgDQpccGFyIEJlbG93IGlzIGEgc2VsZWN0IHRoYXQgV0lMTCB3b3JrIChJIHByb21p c2UpDQpccGFyIA0KXHBhciANClxwYXIgU0VMRUNUIGFjY19ubyAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANClxw YXIgIEZST00gcGVycyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICANClxwYXIgV0hFUkUgYWNjX25vID0gMiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICANClxwYXIgT1IgdHJ1bmMoYWNjX25vLzEwLDApPTIgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANClxwYXIgT1IgdHJ1 bmMoYWNjX25vLzEwMCwwKT0yICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICANClxwYXIgT1IgdHJ1bmMoYWNjX25vLzEwMDAsMCk9MiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAN ClxwYXIgT1IgdHJ1bmMoYWNjX25vLzEwMDAwLDApPTIgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANClxwYXIgT1IgdHJ1bmMoYWNjX25v LzEwMDAwMCwwKT0yICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICANClxwYXIgT1IgdHJ1bmMoYWNjX25vLzEwMDAwMDAsMCk9MiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANClxwYXIgT1Ig dHJ1bmMoYWNjX25vLzEwMDAwMDAwLDApPTIgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICANClxwYXIgT1IgdHJ1bmMoYWNjX25vLzEwMDAwMDAw MCwwKT0yICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICANClxwYXIgT1IgdHJ1bmMoYWNjX25vLzEwMDAwMDAwMDAsMCk9MiANClxwYXIgXHBhcmRc bGkzNjBccGxhaW5cZjNcZnMyMFxwcm90ZWN0IA0KXHBhciBccGFyZFxwbGFpblxmM1xmczIw XGNmMVxwcm90ZWN0IA0KXHBhciBJZiBhdCBmaXJzdCB5b3UgZG9uJ3Qgc3VjY2VlZC4uLi4u LiAgRm9yZ2V0IGl0ISEhISENClxwYXIgDQpccGFyIEphbWllDQpccGFyIA0KXHBhciBccGFy ZFxsaTM2MFxwbGFpblxmMlxmczIwXHByb3RlY3QgDQpccGFyIH0NCgA= --openmail-part-000c1e32-00000002-- --openmail-part-000c1e32-00000001 Content-Type: text/plain --openmail-part-000c1e32-00000001--