SQL String value

[imfarhan]

Hi,
I have a table called SQLTbl, keeps all SQL of my reports

Field Name Value

QueryCode: D-X1
QueryName: EmployList query
SQLQuery: SELECT empno,ename,job..........

I would like to pulls only string/tables values between "FROM" clause and "WHERE" caluse
Eg:-

Select empno,ename,job, deptno,dname
FROM emp, dept innerjoin dept.deptno.emp.deptno
WHERE dept.dname = "XYZ"

So, from the above query I would like to pull only string value b/w FROMm and WHERE as given below
"FROM emp, dept innerjoin dept.deptno.emp.deptno"

I tried

SELECT INSTR(SQLQuery,"FROM") ????
FROM SQLTbl

I hope it does make sense to you

I thiink I have to use INTR or any other function but don't know how. I would appreciate your help.
Farhan

 

[doofusboy]

Assuming your entire SQL string is in cell A1, you could use this formula in VBA to return only the FROM clause into cell B1:

 Range("B1").Value = Mid(Range("A1").Value, InStr(Range("A1").Value, "FROM"), InStr(Range("A1").Value, "WHERE") - InStr(Range("A1").Value, "FROM"))