7 Replies Latest reply: Feb 27, 2013 11:42 AM by Adotey Kwame RSS

    Load where field starts with...

    Adotey Kwame

      Hi any help with the syntax base on the where clause beased on the idea below

       

      load,

      a

      b

      c

      SQL SELECT *

      FROM xxx;

      where field b starts which all records beginning with the numeric  ' 000';

       

      and

       

      filed b contain 0000009,00000009,AAA003452,XXX0643