querying for # in data

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
 
F

fredg

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.
 
Top