Max Vlasov wrote: > trim(col, char(9)) > works, while > trim(col,'\t') > does not.
SELECT trim('ttthello\tt\\\', '\t');
hello
Works as designed.
SQL does not use backslash escaping.
Use char(9) or an actual tab character (' ').
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
