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

Posted by Pete Kamenszky on Stack Overflow See other posts from Stack Overflow or by Pete Kamenszky
Published on 2010-04-12T15:41:09Z Indexed on 2010/04/12 15:43 UTC
Read the original article Hit count: 385

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about exclude