Sybase ASE Soundex Function Issue -Need Suggestion

Applications Programming
1

Dear Team
I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records
Though the command works for characters and provides unique code for similar outputs.
But when i try with Starting numbers ( Followed with Street address ) , soundex does not work efficiently . Below examples show 0000
for 2 distinct address shown. Ideally it should show two different codes as both are distinct values .
Please guide if i am missing anything.

[
 SELECT 
 Street_Lane,
 soundex(Street_Lane) as Street_Lane_Code
 FROM Cities_Table
 where City = 'XYX
 ]

Output

[Street_Lane                    Street_Lane_Code   
 96 Queen lane; Main 200                 0000
 96 Queen lane; Main 200                 0000
 141 Mike Lane                                0000
 141 Mike Lane                                0000
 ]
2

From the ASE documentation at: infocenter.sybase.com

Adaptive Server Enterprise 15.5
> Transact-SQL User's Guide
> Using the Built-In Functions in Queries
> String functions used for character strings or expressions
> Examples of using string functions

The soundex function converts a character string to a four-digit code for use in a comparison.
It ignores vowels in the comparison.
Nonalphabetic characters terminate the soundex evaluation.
This function always returns some value.

There's no additional information regarding soundex function in higher ASE versions.
So looks like you are out of luck here.
The soundex implementation in Sybase apparently works only on strings that contain characters from the alphabet; not on strings that contain numbers/digits.

1 Like