Multipart Identifier Could Not Be Found

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Multipart Identifier Could Not Be Found

Author

Topic

lyleholc
Starting Member

2 Posts

Posted - 2013-05-21 : 19:49:48

Dear All,

I'm new to SQL and I can't figure out the right syntax. I'm trying to code a TSQL statement in SQL Express 2012 to get the Soundex value for a word in a table. The database is WP1, the Table is IPUSQL, the field is Word. I've tried qualifying, using brackets, etc. but to no avail. I'd also like to be able to set the field Soundx to the Soundex value for all the words in the Table IPUSQL. Below is a little snipet from one of my attempted queries.

USE WP1
GO

SELECT SOUNDEX(IPUSQL.WORD)

Much appreciate any thoughts.

Sincerely,

Lyle

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2013-05-21 : 20:07:44

I think you just need
SELECT SOUNDEX(sql.WORD)
FROM IPUSQL sql

and

UPDATE IPUSQL
SET Soundx = SOUNDEX(Word)

Jim

Everyday I learn something that somebody else already knew

lyleholc
Starting Member

2 Posts

Posted - 2013-05-21 : 21:17:20

Hi Jim,

Cool, that worked!

Thank you so much!!

Lyle

UPDATE IPUSQL
SET Soundx = SOUNDEX(Word)
FROM IPUSQL
WHERE IPUSQL.ID = '4'
SELECT * FROM IPUSQL

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources