thanks! so it's DATEPART(dw,'date')

They are both smalldatetime data types. The problem is that MS Access is the frontend and unfortunately, the MS Access default if a date is not supplied (user enters a time) is...

Thanks. But what I am looking for is access to a checkbox that says to script all changes when table edits are made. It was doing this, and for some...

My reasoning on this was that doing some simple concantenation and dressing up the data a bit at the DB level could save network traffic (one field going across rather...

I don't want to see the date, only the time.

successful, thanks!!

I'm getting an error "invalid operator for data type. Operator equals add, type equals text". Here is my text within a view:

 , t2.ProgIntro + CHAR(10) + CHAR(13) + 'Right '...

how about months in my case!!

In this case, "Party" means any entity that can have an address or enter into a contract. A party can be either a person or organization. I prefer to keep the...

thanks. that did it!

Thanks, Gila, that helped.

Thanks Bill, Lowell and Peter.

The column is actually text rather than varchar. Here is my statement:

Insert into dbo.CodeText(CodeID, Text1) (select CodeId, LongDescription from

CodeLookup WHERE LongDescription IS NOT NULL AND Len(LongDescription)>1)

and here is the...

thanks for the help. I can connect to SS over the vpn and can view and edit data directly and from QA. I can upload a table using the DTS...

It's typical for patients to be allergic to several individual drugs (pencillin, sulfa, others), but not necessarily a combination of drugs. I take your thought to mean that they'd have...