Using Change Scripts

Provided by Jim Ferguson, Project Manager

The results of a soundex search to be sorted so that exact matches (or partial matches at the start of the string) were at the start of the list, so I added an expression in the order by clause.

select personlastname

from viewpersonsearch

where soundex(personlastname) = soundex('knapp')

order by

case when personlastname like 'knapp%'

then 0

else 1



Additional Resources



Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

View all FMS products for Microsoft Access All Our Microsoft Access Products



Free Product Catalog from FMS