Question Access Database + Soundex(Sound like Query)

[sonia.sardana]

hi i want to know that how to use sound like query in VB.net with access.

EXAMPLE (SQL) -

create table names (name varchar(100))
insert into names values ('ritu')
select * from names where soundex(name) =soundex('reetu')

OUTPUT-

ritu

 

[newguy]

First your setup is a little off, you insert into fields not the table.
Access queries are much the same as SQL.
example:

Dim queryStr As String = "INSERT INTO name(column1, column2) VALUES(<value1>, <value2>)"

This is a tutorial to get you started.