[sqlite] REQ: How do I change one character in a field value for another

Hi All, I need to change all occurances of a character in a field to another character, as I dont use sqlite very often, I can select the records but cannot work out how to code the "change character" part. Can anyone help? I need to cange all occurences of "~" (tilde) to "-" (dash) the

[sqlite] Newby Question

Hi All, I'm trying to learn SQLITE from a book and am making slow progress. My question is, in the following TRIGGER how do I tell it to only update the single record that the field Interested was updated? its a logical field either TRUE of FALSE, I want the trigger to work when the Field is

[sqlite] NEWBY Question: What would be the best way to get data from a DBF4 database to a SQLite SQB?

Hi All, I am a newcomer to SQLite and would like to know the best way to get data from my DBF4 database to a SQLite SQb. I need to do this because SQLite is used by a USB Device I recently purchased. I am at hobby level for DBF4 but have no exposure to SQLite before. TIA Sorry if this is a