I have a simple query on a db with c200k records in members and c80k records in People:

SELECT
 FirstName + ' ' + LastName + ' ' + KKIDNum as Name,
 ID
FROM
People P

WHERE ID IN
(
SELECT PeopleID
FROM
MembershipDetails
WHERE Current = true
and SocietiesID = 1928
)
ORDER BY Name

In this form it takes about 6.5 sec to run.

If I write it without the concatenation it runs in 2.2 secs.

I need to run the Concat version, is there a way to make it closer in speed to the faster
version??

Adam,

<< In this form it takes about 6.5 sec to run.

If I write it without the concatenation it runs in 2.2 secs.

I need to run the Concat version, is there a way to make it closer in speed
to the faster version?? >>

What does the non-concatenated version look like ?  The concatenation may
take a while, depending upon the number of records returned.  How many
records are in the result set ?

--
Tim Young
Elevate Software
www.elevatesoft.com