@scdecade

the correct values are listed below. Upon looking at it more closely, noticed that I left out cescode so the create table script and the values are below.

@scdecade,

The solution to the original was that I put single quotes around each item listed. The first time I did this, it did not work and so I...

I have no idea what bit flags are so no not using them. Second, the schema is not designed by myself. I am simply problem solving after having been assigned...

Maybe I should create a new question but using that create table script and insert into statement, trying to run this query and getting no results. Any thoughts as to...

@Phil Parkin,

You are probably correct. However, this schema/structure is not decided upon by me.

Not sure why it did not work the first time but put single quotes around each item in the values and it works. Previously, the values all turned red in...