At 11:33 PM +0100 12/2/07, Juan Pablo Garcia wrote:
I want to find "aString" in the column "names"
of a table "people" where I have 2 strings
("aString" and "bString" separated by a comma)
I can´t see a replace command in Sqlite sintax.
Any help will be greatly appreciated,
Unless Marco has added some extra language
expressions/funcctions to the base SQLlite engine
(http://sqlite.org/lang_expr.html) then I think
you are going to have to copy the string to the
RB client, do the manipulation there and then
update the string in it's entirety.
The built-in SQL functions are a bit limited in this respect.
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
http://www.macsos.com.au
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
