INSERT statements

[edwardturner]

Hi,

I am trying to write a series of insert statements to populate a table, however the strings I am trying to insert include characters such as & and / and when the string is delimeted by single quotes it is erroring:

String or binary data would be truncated.
The statement has been terminated.

Example of the insert statement is below:

insert into table_name
(field_name)
VALUES('Health & Safety/Health & Hygiene')

What characters would I use around the string so that these characters can be inserted?

 

[vongrunt]

None in particular. This error simply indicates string is too long - longer than field_name max. length.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)