We have a Vehicles module which holds a VIN field as a textfield. We typically search for VIN's on the last 6 digits and need to allow this in our instance to make it much more user friendly.
Any ideas on how we can achieve this? I'm not sure if creating a custom filter will work as it typically only gives your starts with and not end with.
FYI. The VIN is separate from the Name field and is not shown here.