I'm fairly new to DW. and am trying to extract some embedded characters from a long recordset table in my dynamic ASP VB page. Example:

My Table_col string is: EXTRACT1234FROMTHISTABLE

I would like to extract position 8 through 11 from the above string and return them to a field in my results page. But the "advanced" query page will not take the SQL statement "Substring" I'm sure there is an easy way for a newbie to do this but I haven't found it yet.

Any help?
Thanks in advance,
drrohle