Filtering Items Using a Variable

  • Article

You can use values from variables as part of a filter in Microsoft Jet syntax or DAV Searching and Locating (DASL) syntax. The following example illustrates the use of variables as part of a filter:

fullname = "Dan Wilson" 
' This approach uses Chr(34) to delimit the value.  
criteria = "[FullName] = " & Chr(34) & fullname _ & Chr(34) 
' This approach uses the double quotation mark to delimit the value.  
criteria = "[FullName] = """ & fullname & """" 
' This approach uses the escaped hexadecimal value of the double quotation mark to delimit the value.  
criteria = "[FullName] = "%22" & fullname & "%22""