Try single quotes:

DELETE FROM [dbo].[tblVendorMessage] WHERE VEN_VENDOR_NAME = 'A&EMAN1'

Jon


>Using Data Explorer, I entered the following command against a MS Sql Server table
>
>DELETE FROM [dbo].[tblVendorMessage] WHERE VEN_VENDOR_NAME = "A&EMAN1"
>
>and got the error message "Invalid column name 'A&EMAN1'.
>
>I searched in BOL and found "A change to the table required the table to be recreated. When a table is recreated, the triggers attached to that table are automatically recreated as well." but I'm not sure why deleting a row would require recreating the table.
>
>Can someone tell me what this means and what I need to do?
>
>TIA,