Yes, the not exists criteria within the query seems to work.  Don't know why I didn't consider doing that...thanks guys!

this works:

SET QUOTED_IDENTIFIER OFF

GO

Create table #a1 (a varchar(3000))

insert into #a1 values ("This is Soumil's laptop")

select * from #a1

CORRECTION: criteria should be >1 not >2

SELECT COUNT(City) AS howmany, City

FROM Customers

GROUP BY City

HAVING (COUNT(City) > 1)

if you also want to know how many times they occur you can use a group by query:

SELECT COUNT(City) AS howmany, City

FROM ...

that is strange because if you specify a column that does not exist on a table that does it will not compile

hmmmmmmm!

concatenating does not work (not using xp_sendmail)

code is :

EXEC @hr = sp_OASetProperty @iMsg, 'HTMLBody', @Body

this doesn't work:

EXEC @hr = sp_OASetProperty @iMsg, 'HTMLBody', @Body...

in case anyone is wondering the answer is: path needs to be relative to the server and not the local machine. can be on another machine but it...

Andy, I would like to use integrated nt security though so I don't have to save the password. Here is my connect string:

data source=DBSERV2;initial catalog=PELDMS;integrated security=SSPI;persist security info=False;workstation id=DTHOMPSON02;packet size=4096

...

I think I figured it out. Instead of the NT login, I used a specific login and password and had to allow password saving.

thanks

thanks gregory, but my table has more than one column in its primary key