Re: querying for # in data
From: fredg (fgutkind_at_example.invalid)
Date: 07/06/04
- Next message: -pam: "Limit number of lines retreived within a query"
- Previous message: Grace Marquis: "querying for # in data"
- In reply to: Grace Marquis: "querying for # in data"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 06 Jul 2004 15:19:54 GMT
On Tue, 6 Jul 2004 07:58:17 -0700, Grace Marquis wrote:
> 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
Like "[#]*"
to find records with the # as the first character.
Like "*[#]*"
to find records with the # anywhere in the field.
-- Fred Please only reply to this newsgroup. I do not reply to personal email.
- Next message: -pam: "Limit number of lines retreived within a query"
- Previous message: Grace Marquis: "querying for # in data"
- In reply to: Grace Marquis: "querying for # in data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
