how to join based on substring in sql query?

example: i am joind 2 tables first table 175 056 venkatesh
second table 056 venkatesh NV how can i join....