I have looked at these somewhat related articles for ideas, and did a number of searches like "sqlite ltrim %" but I'm having a surprisingly hard time figuring out what I'm doing wrong.
What I want to do is remove everything before, and including a space in SQLite.
One major issue is that I have to use SQLite from PortableApps, and cannot use MySQL for this.
UPDATE `temp_Week17` SET `c_name`=ltrim(%,' ');
SET c_name = LEFT(c_name, CHARINDEX(' ', c_name) - 1)
WHERE CHARINDEX(' ', c_name) > 0
UPDATE temp_Week17 SET c_name = ltrim(c_name, ' ');
You should concatenate the two string (the trimmed and the space)
UPDATE temp_Week17 SET c_name = ltrim(c_name) || ' ' ;
or you need the space before the trimmed
UPDATE temp_Week17 SET c_name = ' ' || ltrim(c_name) ;
based on the sample provide seems you need substring
UPDATE temp_Week17 SET c_name = ltrim(substr( c_name, instr(c_name, ' '))) ;