4 Replies Latest reply: Nov 28, 2012 5:09 AM by 975710 RSS

    Need to Query , Like it should start with a Character and upto some char

    975710
      Like I am Having a data having the records as following

      ABC1234_XYZ,
      ABC4567_YZA,
      ABC12345_XYZASD,
      ABC23456_XRTYUL,

      Where You can Observe that ABCXXXX_Some and ABCXXXXX_Some , I.e After ABC 4 characters need to be fetched

      And in similar pattern 5 Characters need to be fetched..


      Can Any one Give me the SQL Wildcard for this..


      i.e Like 'ABC%' After ths what is the Condition..