I want to have a count on my customer code but each customer code ends
with his phone number concatenated
Ex . :
customer code 1.63.180.18 has 5 phone number
I so have in the Database customer codes
1.63.180.18.001
1.63.180.18.002
1.63.180.18.003
1.63.180.18.004
1.63.180.18.005
which gives me 5 customer codes although it concerns only 1 customer.
I’ve tried to create an object defined as “substring(,1,11)”
but, although I get the good data (1.63.180.18), it still gives me 5
counts.
Can someone give me a hand ?
Regards,
Arnaud Duminy.
ISD/DEV Dpt.
+32.2.745.[94.87]
Listserv Archives (BOB member since 2002-06-25)