Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    3

    Unanswered: SQL , STRING value match

    emp

    EMPNO ENAME
    ----- ----------
    1 FARHAN
    2 JIMMY
    3 DAVID
    4 JAMES
    emp_full

    ENAME_FULL Job
    ------------- ---
    FARHAN SYED Analyst
    JIMMY JAMES Manager
    DAVID FOX Sales
    PAUL SMITH Markting
    JAMES BRADFORM Admin
    Hi All ,
    I would like to match the above tables (emp/emp_full) , I've used the following SQL but doesn't work , could you please help me.
    Second part of the SQL I also would like to pull the JOB in my result

    Many thanks
    Farhan

    My Attemt is as follows

    Code:
    select * 
    from REFDATA.EMP
    where SUBSTR(ENAME_FULL,1,5)) = ANY
     (select  ENAME_FULL from "REFDATA"."EMP_DETAIL")

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    take a look at the function, LOCATE.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •