how can i insert with single quote strings?

[iostream71]

i have a field that is a varchar, but when i try to do an insert with single quotes, it won't insert. how should i format it to insert correctly

 

[danielhozac]

Could you post your query here? It should insert if it's within single quotes, so it's supposedly the query that is wrong. //Daniel

 

[iostream71]

i think i figured it out. i was trying to simply insert a string that had a single quote, like:

insert into whatever values ('my string \'with quote\'');

i had to format the "'" to "\'"