Chin Chin - 1 year ago 81
SQL Question

Select only values that start with an uppercase letter in sqlite

I have a table with a column

name
. The values in this column can be capitalized or not (e.g. both "adam" and "Adam"). How can I select only values that are capitalized (start with an uppercase letter)?

Answer Source

If you're using SQLite3, you can employ the REGEXP expression

WHERE name REGEXP '^[A-Z]'

There's some good information in this answer regarding installation ~ https://stackoverflow.com/a/8338515/283366

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download