Thanks Homebrew.

Funny old world, that a comic book character should appear in my database diagram!!

Thanks! Much appreciated

Ron, Just tried your indexing....this does the trick!!!

Thanks.

So, you think i should use EXISTS instead of IN? Performs better?

Thanks again

thanks ron.

yes, the EXISTS variation returns the same correct recordset but unfortunately still at 35sec

to answer your earlier q:

@intContactCategory is null

acts...

Thanks. both the tblAgencies and tblContactCategories tables are also small (10 records and 400 records). here are the DDLs:

tblUsers:

CREATE TABLE [tblUsers] (

 [pk_intUserID] [int] IDENTITY (1, 1) NOT NULL ,

 [fk_intAgencyID]...

thanks.

thanks edwin

thanks.

bit surprising that we need to do all this though.

thanks again for your help

ok. I take your point about datatype. However even if I was using the same datatype (see below) there seems to be a problem when one of the cases uses...

ok. stupid me.

I was actually trying to be smart and pick your brains on a different problem I had a few days ago which was something like this (the DESC...

Thanks Frank. That works fine.

Bye the way......

What if I want to sort reverse and put Mr Green on Top

I tried the below code but not working. It seems the DESC...

Thanks Adam. Losts of food for thought here. In the end I decided to split my text field into 3 varchar(8000) fields using substring.

Like your last post I used a...

thanks yan_aung

that helps

thanks rockmoose, works fine now  

Eoin and Greg

Thanks for your replies. I actually tried out Gregs script first before I saw Eoin's one. It worked, very well.

Eoins script looks very similar. Thank you both.

Eamon

Edited by...