[AccessD] Using # in a query.

Darryl

Like "[#]*"

Regards
Steve

-----Original Message----- 
From: Darryl Collins
Sent: Monday, March 26, 2012 11:59 AM
To: Access Developers discussion and problem 
solving(accessd at databaseadvisors.com)
Subject: [AccessD] Using # in a query.

Hi folks,

Blonde moment, this seems simple enough, but I cannot get it to behave 
today.

I have a table with a field that contains text (string) which some of the 
records start with a hash (for example  "#Input", "#Output" and the rest of 
them don't "Delivery" for instance).

I am trying to write a query along the lines of LIKE "#*" so I can isolate 
just the entries that begin with #, but as # is used in other ways in Access 
(and in queries too) I cannot get it to work.

Anyone shine some light on this one?

Cheers
Darryl.



Darryl Collins
Whittle Consulting Pty Ltd
Suite 8, 660 Canterbury Rd
Surrey Hills, VIC, 3127

p: +61 3 9898 3242
m: +61 418 381 548
f: +61 3 9898 1855
e: darryl at whittleconsulting.com.au<mailto:darryl at whittleconsulting.com.au>
w: www.whittleconsulting.com.au<http://www.whittleconsulting.com.au/>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com