On 7 Feb 2011, at 12:38pm, Harish CS wrote:
> Thanks. Trim(X,Y) is useful but I need to remove anything other than '0' - '
> '9' and a few more characters.
> 180+ characters need to be removed (filtered out).
> So I will need to call Trim() so many times.
> Since we cannot write loops I wonder how I can call it many times.
No, you just call it once and list all those characters in the second parameter:
UPDATE contacts SET phoneNumber to TRIM(rawPhoneNumber, 'abcdefghi ...
xyz!@£$%^&()_-={}[]:"|;''\<>?,./')
Note that as above to put an apostrophe inside an SQLite string you double-it.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
