Posted by @sh on 02/27/06 16:57

UPDATE...

I'll definitely be using your suggestions seen as mine didn't work, hehe -
seemed like a good idea at the time, not sure what I thinking looking back
at it now...

Cheers, Ash


"@sh" <spam@spam.com> wrote in message
news:dtv3r4$at1$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
> Thanks to you both for your replies, I did actually try the Group By but
> received the 'Aggregate function' error message that I couldn't quite
> interpret into English....!!!
>
> Many thanks, I'll give those a go - in the meantime I actually used this
> in the end...
>
> SELECT DeliveryID, Address, Organisation, Organisation, Town, County,
> PostCode FROM SOL_Delivery WHERE DeliveryID IN (SELECT DISTINCT
> REPLACE(Postcode,' ','') FROM sol_delivery WHERE CID = CID (ASP Variable)
> ORDER BY Address DESC
>
> ...but I'll replace with your variants if you think the above is less
> efficient?
>
> Cheers, Ash
>

[Back to original message]