I have to write a query to match values in two tables, Table A and Table B , Table A is havingvalues in column XYZ as "91517181","915171812", i want to check if its exist in table B or not , but in table B, the value in column ABC is "9151718", but in another column in table B it is having its match length as "10". Which means it is upto "9151718XXX". So i have to write a query where value from table A should match with value in table B, because in table B, the value is upto 10 characters. Kindly help...I have to write a query to match values in two