Isaac Isaac - 2 years ago 87
SQL Question

How to fetch values from SQLite data except numeric?

Is there a way to fetch only non-alphanumeric values from a SQLite database?

My database values has something like 23abc abc21 but I want to fetch only abc abc.

I have tried using REGEXP_REPLACE, LIKE keyword but its not working in SQLite. I want to execute this in android apps.

Answer Source

Try This on

String firstname1 = "23abc";
firstname1 = firstname1.replaceAll("[^A-Za-z]","");
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download