This test was performed on Windows XP:
PS C:\Documents and Settings\ma088024> sqlite3
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table test (text);
sqlite> insert into test values('_');
sqlite> insert into test values('-');
sqlite> select * from test where text like '-';
-
sqlite> select * from test where text like '_';
_
-
sqlite> .quit
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users