Associate
- Joined
- 26 Oct 2004
- Posts
- 642
- Location
- Up North
I'm having trouble getting what should be a straight forward select query to work in access. Basically I have a list of codes as follows
as123/123
as124/124#
as125/125
as12/145#
you see the pattern!
Basically I want to select just the codes with #'s but using a like"*#*" statement selects everything and a like"*#" selects everyting other than the #'s! Clearly there is something very simple I'm missing here!
as123/123
as124/124#
as125/125
as12/145#
you see the pattern!
Basically I want to select just the codes with #'s but using a like"*#*" statement selects everything and a like"*#" selects everyting other than the #'s! Clearly there is something very simple I'm missing here!