"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >> Which way is it stored in the database? Show the output of this >> statement: >> >> SELECT SongTitle FROM songs WHERE SongTitle like 'hexion'; > > There are 8 records of Hexion in the database, so after a printout > to the console with a carriage return after each value, I basically > get: > Hexion > Hexion > Hexion > Hexion > Hexion > Hexion > Hexion > Hexion
And you are saying the statement SELECT SongTitle FROM songs WHERE SongTitle='Hexion'; doesn't return any rows? With all due respect, I find it difficult to believe. Would it be possible for you to email a copy of the database file to me at [EMAIL PROTECTED] ? Perhaps a stripped-down version, with just enough data to reproduce the problem. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
