RE: [Q] Select Problem
In a word,....
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
FROM pers
WHERE acc_no = 2
OR trunc(acc_no/10,0)=2
OR trunc(acc_no/100,0)=2
OR trunc(acc_no/1000,0)=2
OR trunc(acc_no/10000,0)=2
OR trunc(acc_no/100000,0)=2
OR trunc(acc_no/1000000,0)=2
OR trunc(acc_no/10000000,0)=2
OR trunc(acc_no/100000000,0)=2
OR trunc(acc_no/1000000000,0)=2
If at first you don't succeed...... Forget it!!!!!
Jamie
.......................................................................
Item Subject: WINMAIL.DAT
Could not convert Microsoft Mail Message Data item to text.
Will attempt to 'shar' item as file '000o4u0' at end of msg.
# This is a shell archive. Remove anything before this line,
# then unpack it by saving it in a file and typing "sh file".
#
# Wrapped by openmail at cim0 on Thu Apr 9 11:07:45 1998
#
# This archive contains:
# 000o4u0
#
echo Compiling unpacker for non-ascii files
pwd=`pwd`; cd /tmp
cat >unpack$$.c <<'EOF'
#include <stdio.h>
#define htoi(c) (c<='9' ? c-'0' : c-'A'+10)
main() {
register int c, c2;
while ((c=getchar())!=EOF) {
if (c=='\\n') continue;
c2 = getchar();
putchar((htoi(c)<<4) + htoi(c2));
}
}
EOF
cc -o unpack$$ unpack$$.c
rm unpack$$.c
cd $pwd
echo x - 000o4u0 '[non-ascii]'
/tmp/unpack$$ >000o4u0 <<'@EOF'
789F3E22FE76010690080004000000000001000100010790060008000000E404000000000000E8
0001088007001800000049504D2E4D6963726F736F6674204D61696C2E4E6F7465003108010D80
0400020000000200020001048001001700000052453A205B515D2053656C6563742050726F626C
656D006B0701058003000E000000CE07040009000B0003003A0004002E0101008000003D000000
04003D000C0021004A616D6965204E61736800004F50454E4D41494C3A4A616D6965204E617368
202F4D49532C434F4F4B48414D000000000000000000830D01208003000E000000CE0704000900
0A0035002C00040051010109800100210000004332324337443243393643464431313138433233
30304130323438353338313600FF0601039006005C010000120000000B00230000000000030026
00000000000B0029000000000003002E0000000000030036000000000040003900805E26D09E63
BD011E004200010000000B0000004A616D6965204E61736800004000480080821AD19E63BD011E
007000010000001700000052453A205B515D2053656C6563742050726F626C656D000002017100
010000001600000001BD639ECFE32C7D2CC3CF9611D18C2300A02485381600001E001A0C010000
000B0000004A616D6965204E617368000002011D0C01000000210000004F50454E4D41494C3A4A
414D4945204E415348202F4D49532C434F4F4B48414D000000001E001E0C01000000090000004F
50454E4D41494C000000001E001F0C01000000180000004A616D6965204E617368202F4D49532C
434F4F4B48414D0040000730202C78629D63BD0140000830202C78629D63BD011E003D00010000
000500000052453A200000000003000D34FD370000C83F
@EOF
chmod 660 000o4u0
rm /tmp/unpack$$
exit 0