Perfect! Thank you so much!

Perfect! Thank you very much.

That worked. Thank you very much!

Worked like a charm. I appreciate it very much!

I said varchar but I actually used HexToChar to convert the image.

select PART_ID, dbo.HexToChar(BITS) as BITS

from PART_PO_BINARY

How should my update statement look using HexToChar?

The BITS column is an image data type. When queried it returns "0x5175616C697479205245565F4120312C332C352C37". However, when you view it through the gui it shows "Quality REV_A 1,2,3,8". Their asking me to...

Got it! Thanks for the help. It is appreciated.

Figured it out. SQL Server Agent properties; Alert System; Enable

I was, but from your post it sounds as if it is not possible. I'm learning as I go.

I am trying to build a view that looks at our cust_address table data. However, there will be times when this information will be null. In that case I want...

After discussing the record keeping process with our QA manager, we concluded that sequential numbering is not a requirement. I am just one of those picky people who would rather...

Ok thanks. Is there a way I can keep users from entering duplicate records now that identity is turned off? If I have two users in the form at once...

Ok you convinced me. What is the easiest way to convert this back to a standard column rather than an identity column?

Is there any other way around this? Maybe some code in the Access form? Why would you not recommend populating the lost data. What is the script to insert in...

That worked! Thanks