name value zone
CA129R 2748 East
CA129R 543 west
CA129R 3000 north
CA129R 100 south
....
required output:
name value zone
CA129R 3000 north
Answer:
select * from TestZone where value=3000
(or)
select * from Testzone where value LIKE '%300%'
hope this will help..
let me know any queries..
Regards
Sriram.R