Soundex In Ado.net Dataset Search

[Hemant Mane]

I Want to Use Soundex in Dataset search But it gives "The expression contains undefined function call soundex()." code for Like Function dataset.Tables[0].Select("fname like '"+name+"%'"); and following Code I Want To Use For The Select dataset.Tables[0].Select("Soundex(fname) =Soundex ("+name+")"); Any Solution Please Give Reply As Early As Possible