Prev: Exclude afield when using 'Select *'
Next: Outlook 2007 and problems with RSS Feeds
From: Dimitris on 22 Feb 2010 05:25
Hello, I have a field in a table in which there are asterisks (*) entered in
some data. How can I filter those records in which asterisks are entered?
For example there might be an entry (John*Smith) I need to find all these
entries with asterisks.

Can someone help me?

Thank you
Dimitris

From: Krzysztof Naworyta on 22 Feb 2010 05:58
Dimitris wrote:
| Hello, I have a field in a table in which there are asterisks (*)
| entered in some data. How can I filter those records in which
| asterisks are entered? For example there might be an entry
| (John*Smith) I need to find all these entries with asterisks.
|
| Can someone help me?

(...)
WHERE Field1 Like "*[*]*"

--
KN
From: Dimitris on 22 Feb 2010 06:03
Thank You


"Krzysztof Naworyta" <k.naworyta(a)datacomp.com.pl> wrote in message
news:hlto0r$r90$1(a)news.onet.pl...
> Dimitris wrote:
> | Hello, I have a field in a table in which there are asterisks (*)
> | entered in some data. How can I filter those records in which
> | asterisks are entered? For example there might be an entry
> | (John*Smith) I need to find all these entries with asterisks.
> |
> | Can someone help me?
>
> (...)
> WHERE Field1 Like "*[*]*"
>
> --
> KN

 | 
Pages: 1
Prev: Exclude afield when using 'Select *'
Next: Outlook 2007 and problems with RSS Feeds