Selecting substring of WHERE in query

[pb2000]

I would like to search for records values.

For instance:

ID Name Number
--------------------------
1. First 704
2. Second 60042
3. Third 70

I would like to create query like

SELECT * FROM MyTable WHERE Number= %70% (Namely - includes 70)
Result: 1 and 3

SELECT * FROM MyTable WHERE Number= %04%
Result 1,2

But

SELECT * FROM MyTable WHERE Number= %704%
Result 1

I found HAVING keyword, but it is not the case. There is no INCLUDE or something similar.

[code green]

SELECT * FROM MyTable WHERE Number LIKE '%70%'

[nbiswas]

Solution to Selecting substring of WHERE in query

You cannot use ColumnName = %Value% expression. You need to use

LIKE operator.

Try this

declare @t table(id int identity, names varchar(50), number int)
insert into @t select 'First', 704 union all select 'Second', 60042 union all select 'Third', 70
select * from @t

Query 1:

SELECT * FROM @t WHERE Number like '%70%'

id           names      number
1	First	704
3	Third	70

Query 2:

SELECT * FROM @t WHERE Number like '%04%'

Id           names    number

1	First	704
2	Second	60042

Query 3:

SELECT * FROM @t WHERE Number like '%704%'

id           name     number

1	First	704

Hope this helps