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---- <http://www.westrowops.co.uk>
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
