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,