Free Resources from FMS

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.

 

Free Catalog

 

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

end,

personlastname

 


Return to the tips page