Select ONLY the text that BEGINS with a given letter RRS feed

  • Question

  • User1504639868 posted

    Let’s say I have the following data in a text file



    ZENworks Asset Management - Client Apps


    Microsoft Internationalized Domain Names Mitigation APIs


    FileZilla Client --Version:


    7-Zip 9.20


    hpzTLBXFX --Version: 002.002.00170


    Mozilla Firefox 23.0.1 (x86 en-GB) --Version: 23.0.1


    hpzTLBXFX --Version: 004.014.00150


    ZyXEL G-302 v3  Utility --Version: 3.00





    What would be the correct Log Parser query to select ONLY THE TEXT BEGINNING WITH THE LETTER Z

    Would some one kindly provide me with an example?

    Thursday, September 5, 2013 12:47 PM

All replies

  • User56485982 posted
    SELECT * FROM table WHERE name LIKE '[Z]%'

    Monday, June 30, 2014 10:16 AM