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

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

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##'