querying for # in data

  • Thread starter Thread starter Grace Marquis
  • Start date Start date
G

Grace Marquis

How do I query for records containing the # as part of the
data in a field.

For example:

row 1 FB
row 2 #FB
row 3 00
row 4 00
row 5 #RE

I need only see rows 2 and 5.

Please help...Thanks

Grace
 
How do I query for records containing the # as part of the
data in a field.

For example:

row 1 FB
row 2 #FB
row 3 00
row 4 00
row 5 #RE

I need only see rows 2 and 5.

Please help...Thanks

Grace
Click to expand...

Like "[#]*"
to find records with the # as the first character.

Like "*[#]*"
to find records with the # anywhere in the field.
 
Back
Top