Richard Boyd wrote:
Use the built-in quote() function.
--
Ok I think I found it. (http://www.sqlite.org/lang_expr.html)
I'm not really familiar with this method of calling a function in an
expression. Is there away to have it only quote the TEXT columns and not the
INTEGER columns, or does it do this anyway by default?
Ideally I'd like the entire row returned with TEXT strings in quotes but
everything else left as normal.
SELECT * from Table0 quote(??some expression in here??);
????
Sorry, I'm a bit lost. Are there any code snippets on the usage?
Thanks again.
R.
Richard,
Try this:
select int_col, quote(text_col), quote(other_text_col) from table;
HTH
Dennis Cote
