GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 198 of 202    Print  
SQL Soundx
What is soundx in SQL?


  
Total Answers and Comments: 2 Last Update: August 14, 2009     Asked by: Shivani Goel 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 01, 2009 13:55:22   #1  
sunraajkumar Member Since: June 2008   Contribution: 7    

RE: SQL Soundx
Soundex function is used to find the phonetic representation of string

Syntax
----------

Soundex(CHAR)

Query
--------

SELECT Empname FROM Employee WHERE SOUNDEX(EMPNAME) SOUNDEX('SMYTHE')

 
Is this answer useful? Yes | No
August 14, 2009 02:24:32   #2  
sure_prince Member Since: June 2009   Contribution: 5    

RE: SQL Soundx
This is Soundex Function is useful to select the data according to the sound of
the given value but not compare with the casing of that letters.

For Example:


SQL> SELECT * FROM emp WHERE Soundex(Ename) Soundex('Analyst');


It select all the Analyst details in emp table in anuy case...

 
Is this answer useful? Yes | No

 Related Questions

What is soundx in SQL? 
Latest Answer : This is Soundex Function is useful to select the data according to the sound of the given value but not compare with the casing of that letters.For Example: SQL> SELECT * FROM emp WHERE Soundex(Ename)=Soundex('Analyst'); It select all the Analyst ...


 Sponsored Links

 
Related Articles

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape