soundex error

Doug Barger · Sep 24, 2019

select description,soundex(description) as sx from
parts
this generates the following error
<<<<<<<<<<<<<<<<<<<<<<<<
[LNA][Pervasive][ODBC Engine Interface]Error in expression: soundex ( description )
>>>>>>>>>>>>>>>>>>>>>>>>

mirtheil · Sep 24, 2019

What version of PSQL are you using? The soundex wasn't introduced until PSLQ v10. Also, what data type is the "description"? Does this query work against the DEMODATA database?

Code:

select description, soundex(description) from course

I tested it using PSQL v11 and got a result set.

Mirtheil

http://www.mirtheil.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

soundex error

Doug Barger

Programmer

mirtheil

Programmer

Similar threads

Part and Inventory Search

Sponsor