In SQL how to I exclude a record if there are more than 3 characters after a dash..

Question

In SQL how do I exclude a record if there are more than 2 characters after a dash..

Example I only want to return records that match the following AA00000-0

but the table also has recoreds like AA0000-000,AA0000000-00

I need to return only records that have a single digit after the dash

Answer 1

LIKE '%-[0-9]'

Filler Filler Filler Filler

Answer 2

Assuming SQL Server:

SELECT * FROM records WHERE id NOT LIKE '%-[0-9][0-9]%'

Answer 3

Use a like statement.

Field Like '%-[0-9]'

Answer 4

What database are you using?

In MSSQL you could: where fld not like '%-__'

Answer 5

As mentioned, digit matching is not consistent across databases.

For SQL Server, you can do:

MyColumn LIKE '%-[0-9]' (will get it with only a digit after the dash)

Database-agnostic:

MyColumn LIKE '%-_' (would match a digit or 1 letter after the dash, but that may be sufficient)

Answer 6

thanks for all the answers, the soluition I used was

Like '%-_'

The single underscore represents the first digit after the dash