Extract first word in a SQLite3 database <p>I have a SQLITE3 database wherein I have stored various columns. One column (cmd) in particular contains the full command line and associated parameters. Is there a way to extract just the first word in this column (just before the first space)? I am not interested in seeing the various parameters used, but do want to see the command issued.</p> <p>Here's an example:</p> <p>select cmd from log2 limit 3;</p> <pre><code> user-sync //depot/PATH/interface.h user-info user-changes -s submitted //depot/PATH/build/...@2011/12/06:18:31:10,@2012/01/18:00:05:55 </code></pre> <p>From the result above, I'd like to use an inline SQL function (if available in SQLITE3) to parse on the first instance of space, and perhaps use a left function call (I know this is not available in SQLITE3) to return just the "user-sync" string. Same for "user-info" and "user-changes".</p> <p>Any ideas?</p> <p>Thanks.</p>