Kris
|
Posted: 02/02/2002, 7:21 AM |
|
How do I search a VIN (Vehicle Identification Number - 17 chars) field from the last 8 chars? for example in database: 1FAFP10P3XW291793. On the form, I want to search from XW291793.
Thanks
|
|
|
Ev Southwick
|
Posted: 02/02/2002, 10:00 AM |
|
Can't you just use a like or contains in the where clause of your query? Take the search string variable and do something like:
/* IS VIN a full VIN ? i.e. 17 chars len?
if strlen(trim($fldvin_number)) = 17
{
$fldvin_number = substr($fldvin_number,10,8);
}
The comparison will then be made on the last 8 chars of search string.
I think it would go in the search result form Open event. You need to check the generated code to see exactly where you need to put the snippet.
Someone please correct me if I am in error.
|
|
|
|