[AccessD] Using # in a query.

Darryl Collins darryl at whittleconsulting.com.au
Sun Mar 25 17:59:02 CDT 2012


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/>



More information about the AccessD mailing list