> 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
Simplified:
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select '_' like '-';
0
sqlite> select '-' like '_';
1
sqlite> .quit
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
assuredcommunications(tm)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
