Linuxed <linux...@yahoo.com> wrote: > Is it possible to use regexp within a trim function? For example, if I wanted > to remove every alpha-numeric character at the end > of a string I could use the statement below. Is there any way to > simplify/condense the statement through regexp or a wildcard > character?
Not with a built-in function. You can always write a custom function, and do whatever you want there. > Also, if I want to remove single or double quotes in addition to > alpha-numeric characters how can I include them in > the string of characters to trim? I've tried \' and \" without success. You include double quotes as-is. You escape an apostrophe by doubling it up: 'Here''s a "quote"' -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users