sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hello Guyz,
I want to search for these string characters (144289502 , 155123302 , 155701510 , 174761410) from a table.
Right now iam writing 4 select queries for 4 numbers.
Eg : select * from inttest.inet_case where case_pol_no like '%144289502%'
For each of these policy numbers. And case_pol_no is CHAR data type
How can i write a query to check whether these policy numbers are in table or not in a single query. And also display them |
|