-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 RB Smissaert wrote: > I would like to do a where on a text field and check if the values have > non-numeric characters, > which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a space > character. > Is this possible without using a UDF or a very long OR construction?
You can check to see if the string is zero length after calling trim on it. For example trim(value, "01234567890 ") will remove all those characters. Also you do know that those aren't the only way numbers are written? See the pdf at the bottom of http://www.unicode.org/notes/tn21/ which shows the Tamil number system and uses different digits. BTW there are over 66 million Tamil speakers, it is an official language of several countries and has a long history. I'll let you off the hook for not considering Roman Numerals though :-) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkryBL8ACgkQmOOfHg372QShCQCfT80ioArm0O5RFinQew0wnBr7 hfcAniv7GeCmU8RIFM/5VjbO8+MklUp0 =t+LY -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
