View source for Using Sounds Like Criteria in Reports

{{SeqReportPageHeader}} 

You can use sounds like criteria within a report to find values that are similar phonetically to the value entered. This uses the '''[http://en.wikipedia.org/wiki/Soundex soundex]''' phonetic algorithm feature.

* In the Calculated Field you should enter:
:''soundex([this])''
* And in the Criteria:
:''=soundex(???)''

[[File:Soundex.png]]

The column with this syntax is not normally displayed in the report, as it will display the soundex phonetic representation of the value rather than the word.

Note:
* The Soundex function is intended to work well with strings that are in the English language only. Strings in other languages may not produce reliable results. 
* Soundex may not provide consistent results with strings that use multi-byte character sets, including UTF-8. 

{{PrevNextStart}}	[[Using Wildcard Criteria in Reports]]
{{PrevNextMid}}	[[Specifying Multiple Criteria in Reports]] {{PrevNextEnd}}	

[[Category:Reports]][[Category:Criteria]]