On 7 Dec 2009, at 5:56am, greensparker wrote: > i want to check the first character should not be an special character. > [by before insert trigger] > how to do it? > i thought of using ascii function but i didnt find in sqlite.
substr(X,Y,Z) will get you the first character. I'm not sure what you mean by 'special', but the core functions are here: http://www.sqlite.org/lang_corefunc.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
