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

[Graham Wickens]

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 select statement is thus:

select OperatorFlagCode from Aircraft where OperatorFlagCode like '%~%'


thanks in anticipation


-- 
¿¿¿
   (ô ô)   [EMAIL PROTECTED]
ooO-(_)-Ooo   
Wot! No SBS?
IAT Boscombe Down Aircrew Transport 1989
RIAT Fairford Checklist Team 1990-2008
RAF Waddington Checklist Team 1995-2007
RNAS Yeovilton Checklist Team 2005,2007

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Newby Question

[Graham Wickens]

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 
TRUE.



*create trigger* sbslogger* after update of *Interested* on *Aircraft *
begin
update *Aircraft* set *UserString1 *= Registration;
update *Aircraft *set *UserString2* = 'PAGANHILL SBS';
update *Aircraft* set *UserString3* = current_date;
end;

*the above works, but of course does the whole table ! and I am now stuck!

thanks in anticipation
**

--
   ¿¿¿
  (ô ô)   [EMAIL PROTECTED]
ooO-(_)-Ooo   
   Wot! No SBS?

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

[Graham Wickens]

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 repeat message, I am not sure if the first request  
reached this list.


--
 ¿¿¿
(ô ô)   [EMAIL PROTECTED]
ooO-(_)-Ooo     



-
To unsubscribe, send email to [EMAIL PROTECTED]
-