Subject: RE: Unusual sort
Hi Jim
it seems that you cannot create an index with a function soyou will need to
establish a separate 12 character column which has all of the URL entries
insertedalphabetically in ascending order (fully padded with www.
prefix)backup your DBALTER TABLE table ADD
Hi Jim
it seems that you cannot create an index with a function soyou will need to
establish a separate 12 character column which has all of the URL entries
insertedalphabetically in ascending order (fully padded with www. prefix)backup
your DBALTER TABLE table ADD TwelveCharacterURL CHAR(12)
On 24-nov-2007, at 0:29, Jim wrote:
I have a table containing web site host names, most of them having
both a "name.com" and "www.name.com" version, that I'd like sorted
in the following manner:
axxx.com
www.axxx.com
bxxx.com
www.bxxx.com
wxxx.com
www.wxxx.com
zxxx.com
www.zxxx.com
Any wa
