**Search different SQL column with similar where clause**

Replace a column in the where clause and convert all numbers from text to numeric, by replacing the leading 0 with the code 359.

##### Start file

SELECT * FROM numbers WHERE local_number IN ( "058307327", "058307328", "058307329" )

##### End file

SELECT * FROM numbers WHERE int_number IN ( 35958307327, 35958307328, 35958307329 )

#### View Diff

1,4c1,4 < SELECT * FROM numbers WHERE local_number IN ( < "058307327", < "058307328", < "058307329" --- > SELECT * FROM numbers WHERE int_number IN ( > 35958307327, > 35958307328, > 35958307329

### Solutions

**The best way to learn is to practice**. Below, you will find some of the solutions other golfers have entered. To unlock higher ranked solutions, submit your own entry which does as well or better than the solutions you can currently see - climb the ladder!

Check out these helpful resources to improve your Vim skills... *Game on.*

Unlock

**17**remaining solutions by**signing in**and submitting your own entry