| Ora-00904 Error [message #97276] |
Tue, 19 February 2002 09:10  |
Nicholle
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
Hi
I am hoping you could assist me
I am developing an interface to query a database of lease owners. So Soundex comes in handy in cases where misspelt surnames would mean the non-retrieval of records.
The problem I am having is on applying the SQL statement to the database
"select surname from leases where SOUNDEX(surname) = SOUNDEX('Smith')"
It is telling me ORA-00904 Invalid Column Name.
By any chance would one have to create a new field to hold the soundex values generated from by the surname field in the database or is it enough to have just the one on one comparison of SOUNDEX values and where there is a match pull that record. I am developing my application in VB6, using ADO, connected to an Oracle database.
I have used other SQL queries with the same column and they worked but just on applying the SOUNDEX function I get this error. Do you have any thoughts on what it may be.
Thanks
Nicholle
|
|
|
|
| Re: Ora-00904 Error [message #97303 is a reply to message #97276] |
Wed, 27 February 2002 14:24  |
Venkat
Messages: 110
Registered: February 2001
|
Senior Member |
|
|
Nicholle,
It is working fine. I've got the error message like
ORA-00904: invalid column name
when I gave it in like soundex("op35sqm") double quotes.
SQL> select testlocation from testwip where soundex(testlocation) = soundex('op35sqm');
TESTLOCATI
----------
oP35SQM
SQL>
Thanks
Jothi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
