Never mind I see you are using LIKE. Okay, so try the Firefox SQLite plugin and run the query there. If it works there and not in Livecode, well you have divided and are prepared to conquer?
Bob On Mar 12, 2014, at 08:51 , Chris Sheffield <[email protected]<mailto:[email protected]>> wrote: SELECT wordID, targetWord, questionStem, answer, distractor1, distractor2 FROM words WHERE words.wordID LIKE '5-C%' ORDER BY random() LIMIT 1 _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
