« Previous Next »

Thread: * in LIKE clause

Last post 10-02-2009 1:49 PM by ksingla. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 10-01-2009, 8:18 AM

    * in LIKE clause

    Reply Contact

    Hello,

    we have following entries (cs(Referer))  in our logfile:

    http://xxxxx.yyyy.zz/corpnews/news1eng.nsf/*00001*/..... which have to be counted.

    How can I handle the * inside a LIKE clause? %* doesn't work.

    Unfortunately it's not possible to use /%00001%/ ... because there are other cs(Referer) which

    will be (e.g. 000011 ...)  also counted then.

    Thank you very much.

    regards 

    Andreas

    P.S.: please excuse my clumsy english.

     

  • 10-02-2009, 1:49 PM In reply to

    • ksingla
    • Top 25 Contributor
    • Joined on 06-13-2006, 11:02 PM
    • Redmond, WA
    • Posts 863

    Re: * in LIKE clause

    Reply Contact

    I tried on a file which had * in the entries and I was successfully able to folder entries with "*123*" using following query.

    logParser.exe "select * from teststar.txt where text like '%*123*%'"

    Thanks,
    Kanwal

    Follow me on twitter at http://twitter.com/kjsingla
Page 1 of 1 (2 items)
Microsoft Communities