Community discussion forum

Access, VB and SQL Server wildcard characters

• • Reply

  9 years ago

  by Developer Fusion Bot

  Developer Fusion Bot

  , United Kingdom

  Joined 2 years ago

  This thread is for discussions of Access, VB and SQL Server wildcard characters.

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  3 years ago

  by dotun_ayansiji

  dotun ayansiji

  lagos,nigeria, Nigeria

  Joined 3 years ago

  i believe examples of the usage of these wildcards should be given in more real-life applications
  

  Report abuse
• • Reply

  1 year ago

  by takas20

  Diarmuid Pigott

  , Australia

  Joined 1 year ago

  
  customer ids beginning with "C10" (can have any number of characters or no characters at all)
  17 found from select * from booking where [customer id num] like 'C10*'
  customer ids beginning with "C100" and one character
  16 found from select * from booking where [customer id num] like 'C100?'
  customer ids beginning with "C100" and two characters
  17 found from select * from booking where [customer id num] like 'C10??'
  customer ids beginning with "C100" and one character of 1,2 or 3
  10 found from select * from booking where [customer id num] like 'C100[123]'
  customer ids beginning with "C100" and one character which is not one of 1,2,3
  6 found from select * from booking where [customer id num] like 'C100[!123]'
  customer ids beginning with "C100" and one number
  16 found from select * from booking where [customer id num] like 'C100#'
  customer ids beginning with "C100" and two numbers
  17 found from select * from booking where [customer id num] like 'C10##'

  Report abuse