Quote:
Originally posted by Pragma
It's also possible to run it through a regex, ie:
If it matches the pattern of dddd-dd[.], then chop off the last digit and replace it with a %, otherwise match it with a different pattern.
|
The problem there, though, is that then information specific to the 6648-84T would be returned.
I think you're on the right track.
I'm going to play with this a bit:
Code:
SELECT books FROM info WHERE keyword IN('6648-84U','6648-84\*', '6648-8\*\*', etc)
and we'll go from there.
MPEDrummer