I am in the process of moving data from flat files to a sqlite database. I first search through a row and replace ' with '' for such occurrence as o'riley/joe's. My assumption was that for each column I could bookend each column with a ' like '123' and that will allow the data to pass to the proper column in the database(this particular table all the columns are of a type text/varchar). But I have columns/fields that contain /, or - somewhere in the column and they are being rejected.
What character do I use to allow those characters to pass on as is? I a newbie to sqlite, but do have experience with MYSQL, most of which has to do with extracting/selecting data from databases. Joe Lanier Lanier & Associates 615 N. Main St. Suite 120 Euless, Texas 76039 Phone: (214)236.8308 " When we accept tough jobs as a challenge to our ability and wade into them with joy and enthusiasm, miracles can happen." Dr. T.L. Bridges _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users