-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I would like all those on the same street grouped together. Is there any
> tricks to getting the street names sorted first, possibly where numbers
> and strings separate?
As some have demonstrated, this can be a difficult problem. Your best bet
How will that work when people reside at
123A Some St.
Address that need to be sorted and/or grouped in any way should be
stored as multiple fields.
door number
door number suffix Most often a letter
street name prefix Section
street name
street name suffix Direcetion
Richard Poole wrote:
On Thu, Oct 28, 2004 at 03:36:00PM -0400, Robert Fitzpatrick wrote:
I would like all those on the same street grouped together. Is there any
tricks to getting the street names sorted first, possibly where numbers
and strings separate?
You could do something like
CREATE FUNCTI
On Thu, Oct 28, 2004 at 03:36:00PM -0400, Robert Fitzpatrick wrote:
> I would like all those on the same street grouped together. Is there any
> tricks to getting the street names sorted first, possibly where numbers
> and strings separate?
You could do something like
CREATE FUNCTION streetname(
Thanks to some help here on the list, I've been able to get addresses
sorting pretty well, but now I have a issue with same addresses on
different streets not grouping the streets. This is what I'm using a
substring search in the ORDER BY statement now like in this view:
SELECT tblhudsimilargroups