> "select * from symbols where pattern = 'n'" returns no records.
> But when I do "select * from symbols where pattern like 'n'" it returns the > matching records. I am wondering why this is happening? What you think is 'n' probably isn't. Perhaps it is 'n ' or some other whitespace variation. Or it could be a problem with your C interface. Using the sqlite3 command line tool, try: .mode insert select * from symbols; Reply here with one of the lines showing an 'n'. The insert syntax should make it clear what's going on. Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users