How about this:
EXTRACT_VALUE(REPLACE_str(cs(Cookie),';+','&'), 'ASP.NET_SessionId', '&') AS Cky,
WHERE cs-uri-stem like '%.doc' OR cs-uri-stem LIKE'%.docx' AND date >= '2012-07-01'
Unlike SQL, You have to specify the columns you're interested in explicitly instead of adding a
* column wildcard (i.e. the
<other_column_names> placeholder in the query above).
You also need to make sure that IIS is configured to log cookies as well in your logging settings (assuming you're using the W3C logging format):