Sorry for taking so long to respond. The prefix thingy is definetly
attractive for future development and I had already discovered them to be a
challenge. However, i have noticed all kinds of ways people tend to write
their number, including omitting the + or 00 .. so at this time, for this
task, I
Hello,
Le 3/07/09 12:53, Dimitri Fontaine a écrit :
Hi,
Le 3 juil. 09 à 11:44, Jennifer Trey a écrit :
I would like to run a query and group several rows based on a phone
number.
However, the same phone number might have a prefix on occasion, example :
name | phone_number
Hi,
Le 3 juil. 09 à 11:44, Jennifer Trey a écrit :
I would like to run a query and group several rows based on a phone
number.
However, the same phone number might have a prefix on occasion,
example :
name | phone_number
--
james | 123456
james | 00441234556
as you can s
On Fri, Jul 3, 2009 at 8:32 PM, Guy Flaherty wrote:
>
>
> On Fri, Jul 3, 2009 at 7:44 PM, Jennifer Trey wrote:
>
>> Hi,
>>
>> I would like to run a query and group several rows based on a phone
>> number.
>>
>> However, the same phone number might have a prefix on occasion, example :
>>
>> name |
On Fri, Jul 3, 2009 at 7:44 PM, Jennifer Trey wrote:
> Hi,
>
> I would like to run a query and group several rows based on a phone number.
>
> However, the same phone number might have a prefix on occasion, example :
>
> name | phone_number
> --
> james | 123456
> james | 00441
What is the output you are trying to achieve?
> However, the same phone number might have a prefix on occasion, example :
>
> name | phone_number
> --
> james | 123456
> james | 00441234556
> james | 555666
> sarah | 567890
> sarah | 567890
>
> as you can see, the first 2 James
Hi,
I would like to run a query and group several rows based on a phone number.
However, the same phone number might have a prefix on occasion, example :
name | phone_number
--
james | 123456
james | 00441234556
james | 555666
sarah | 567890
sarah | 567890
as you can see, th
