Delete anything with # symbol in field

's Computer Specifications

I have a table where I want to delete and items that has ## in the Brand
name. Example would be ##VISTA. If is set up a Delete query with Like
"*##*" in the criteria field, it deletes anything with a number in
the Brand name, not anything with ## in the name. Assume Access see the # as
any number. Is there way for it to look at # as a text and not as any
number?

's Computer Specifications

Supe wrote:
> I have a table where I want to delete and items that has ## in the Brand
> name. Example would be ##VISTA. If is set up a Delete query with Like
> "*##*" in the criteria field, it deletes anything with a number in
> the Brand name, not anything with ## in the name. Assume Access see the # as
> any number. Is there way for it to look at # as a text and not as any
> number?

LIKE "*[#][#]*"

James A. Fortune
(E-Mail Removed)

's Computer Specifications

James A. Fortune wrote:

> LIKE "*[#][#]*"

This also worked:

LIKE "*[##]*"

James A. Fortune
(E-Mail Removed)

's Computer Specifications

Great. Thanks!

"James A. Fortune" wrote:

> Supe wrote:
> > I have a table where I want to delete and items that has ## in the Brand
> > name. Example would be ##VISTA. If is set up a Delete query with Like
> > "*##*" in the criteria field, it deletes anything with a number in
> > the Brand name, not anything with ## in the name. Assume Access see the # as
> > any number. Is there way for it to look at # as a text and not as any
> > number?
>
> LIKE "*[#][#]*"
>
> James A. Fortune
> (E-Mail Removed)
>

's Computer Specifications

On Wed, 7 Nov 2007 13:18:00 -0800, Supe <(E-Mail Removed)>
wrote:

>I have a table where I want to delete and items that has ## in the Brand
>name. Example would be ##VISTA. If is set up a Delete query with Like
>"*##*" in the criteria field, it deletes anything with a number in
>the Brand name, not anything with ## in the name. Assume Access see the # as
>any number. Is there way for it to look at # as a text and not as any
>number?

Yes; you can override the interpretation of a wildcard character by enclosing
it in square brackets. A criterion of

LIKE "[#][#]*"

will return only records with two literal octothorpes at the beginning of the
field.

John W. Vinson [MVP]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to delete paragraph symbol	Los Gatos Gal	Microsoft Outlook Contacts	0	9th Feb 2010 01:58 AM
@ symbol in field	dudemanmax	Microsoft Excel Misc	6	20th Dec 2009 04:56 PM
delete the actual symbol *	simple user with problem	Microsoft Excel Misc	2	3rd Jul 2008 09:02 PM
how do I delete all text before or after a symbol?	=?Utf-8?B?VG9ueQ==?=	Microsoft Excel Programming	5	27th Jan 2007 08:48 PM
Delete all file using * symbol	Pujo Aji	Microsoft C# .NET	2	18th Jan 2005 08:57 AM