jason d wrote: > I believe you misunderstood my problem. Its not that records dont exist. and > select statement for Bob does work. a select * does display all the data. > its the names with dashes that dont shows up. and i have 40,000 records. > any with dashes do not give any result on a pure select statement. but if I > select on any other column and then work on the resultset it is ok. for > example I may choose column projectname since it does not have a dash (-) in > it. The information is clearly there, just its as if it does not equate to > anything at all. > > SELECT * from Groups WHERE name = 'jean-baptiste' ; zero result.
What does this statement return: select name, hex(name) from Groups where name like '%jean%'; My guess is, you either have leading and/or trailing whitespace around the value, or the dash in the middle is not U+002D (HYPHEN-MINUS) but some other Unicode character that looks like a dash, e.g. U+2013 (EN DASH). The hex dump would tell. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
