Create SQL 'LIKE' Statment that looks for specific Patterns of numbers and letters
Posted
by tyguy840
on Stack Overflow
See other posts from Stack Overflow
or by tyguy840
Published on 2010-06-16T15:33:37Z
Indexed on
2010/06/16
15:42 UTC
Read the original article
Hit count: 160
Is it possible to use LIKE in a SQL query to look for patterns of numbers and letters. I need to locate all records where the specific field data has the pattern (2 Numbers,1 hyphen, 3 Letters) ## - AAA I am using SSMS with SQL Server 2008. Any help would be appreciated. THANKS.
© Stack Overflow or respective owner