title: How to join two tables based on substring values of fields?
body: <p>I am having problem with sql. I want to join two tables,  employee and class instructor. Condition is that employee is having unid column like  'u0871457' where as class instructor is having EmplId as '00871457'.</p>
  
  <p>I just want to replace the first character of EmplId to 'u' to join to match the string coming from unid . How can I do that? I have tried this so far :</p>
  
  <pre><code>select e.name, i.name
  from  Employee e
  inner join Instructor i on SUBSTR(e.id,1, LENGTH(e.id )) = SUBSTR(i.id,1, LENGTH(i.id ))
  </code></pre>
  
  <p>but this is resulting into a blank resultset. </p>
  
  <p>Any help will be appreciated. Thanks for your time! </p>