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.