This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Hi /r/MSACCESS,
Thanks very much to those that helped with my queries yesterday. I managed to figure out what was wrong thankfully, though now something which I thought would be easier is turning out to be more tricky...
My code previously was:
SELECT ........
FROM ........
WHERE Left(ID,4) IN ('XXX1','XXX2','XXX3',....);
This picked up all of the entries with XXX1 etc. as the first 4 characters.
Now I want to try do a similar code but instead of doing a wildcard on the first 4 characters (XXX1), I want to do the code for the entire string, which is a mixture of numbers, letters and occasionally spaces. I tried altering my code to:
SELECT ........
FROM ........
WHERE ID IN ('XXXYZZ#XY',....);
but it returned no results - any suggestions?
Many thanks
Subreddit
Post Details
- Posted
- 7 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/MSAccess/co...