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