SQL How to target a specific part of a string

Question

I have a varchar(11) table and all its entries will look something like this.

Table
123456-7890
101112-1314

I need to find everything that has

??12??-????

(? Being any character) How would I do this?

Edit: Thanks bill!!

SELECT * FROM myTable WHERE myfield LIKE '__12%'

Is what i was looking for :)

Martin Smith · Accepted Answer · 2013-03-10 21:32:25Z

4

WHERE YourColumn LIKE '__12__-____'

The _ means "match any single character"

answered Mar 10, 2013 at 21:32

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bill · Accepted Answer · 2013-03-10 21:35:24Z

1

Assuming you're using ANSI SQL, what you're looking for is '_':

SELECT * FROM myTable WHERE myField LIKE '__12__-____'

For most Microsoft products, the question mark, as you used it is, is correct.

answered Mar 10, 2013 at 21:35

Bill

3,6926 gold badges37 silver badges47 bronze badges