This discussion is archived
4 Replies Latest reply: Nov 28, 2012 3:09 AM by 975710 RSS

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

975710 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points