locked
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

    Z

     

    ZENworks Asset Management - Client Apps

     

    Microsoft Internationalized Domain Names Mitigation APIs

     

    FileZilla Client 3.6.0.2 --Version: 3.6.0.2

     

    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

     

    EasyZip

     

     

    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