CREATE TABLE Table1

(query_name varchar(136))

;

INSERT INTO Table1

(query_name)

('SELECT * FROM SYSIBM.SQLCOLUMNS'),

('SELECT * FROM SYSIBM.SYSDUMMY1'),

('SELECT CCID, CCCODE FROM V820.ZCC ZCC JOIN V820.ZCI ZCI ON ZCC.CCID = ZCI.CCID WHERE trim(CCCODE) NOT IN (''89090'',''89089'',''89087'')'),

('SELECT * FROM V820.IIM')

;

SUBSTRING(

query_name,

CHARINDEX('FROM ', UPPER(query_name)) + 5,

ABS(LEN(query_name) - CHARINDEX('FROM ', UPPER(query_name)))

) AS AUXILIARFIELD

FROM

Table1

SUBSTRING(AUXILIARFIELD,

1,

IIF(CHARINDEX(' ', AUXILIARFIELD) = 0,

LEN(AUXILIARFIELD),

CHARINDEX(' ', AUXILIARFIELD))) AS EXPECTEDRESULT

FROM (

SELECT

SUBSTRING(

query_name,

CHARINDEX('FROM ', UPPER(query_name)) + 5,

ABS(LEN(query_name) - CHARINDEX('FROM ', UPPER(query_name)))

) AS AUXILIARFIELD

FROM

Table1

) AS AUXILIARQUERY