insert string

how do i insert a string "N.A" into a column who define as varchar datatype...i tried to use cast but cannot...need to know the right way..

Insert into Table (xxx) Values ("N.A") ? or ?

INSERT INTO TABLE(fieldname) VALUES('N.A');

Is it returning some sort of an error?

the reason why i cant get the other 5 rows is because of this!!!...there are null values...so cant get!!!kakakak thanks alot

hmm..i got error for trying that...(the one you give me..)...

nope this wont work

Code:

---

INSERT INTO TABLE(field1,field2) VALUES('N.A',xxxx)

---

What's the error, and what is xxxx?


kakakakka.

thanks..no eoor already in this part...but have other bugs to resolve..:(

Uhm... yes. :)