Hi,
I have a table stored with names. One of the column is name.
Example Name= 'John'
I have created a search functionality. How can I add sql seach so that
it return 'John' even when 'john' or 'JOHN' is typed in the search box.

desi90 wrote:[color=blue]
> Hi,
> I have a table stored with names. One of the column is name.
> Example Name= 'John'
> I have created a search functionality. How can I add sql seach so[/color]
that[color=blue]
> it return 'John' even when 'john' or 'JOHN' is typed in the search[/color]
box.

Try using the StrConv function on the search text with the vbProperCase
setting.

James A. Fortune

Lockheed-Martin's Joint Strike Fighter (F-35) will probably be the last
manned fighter used by the U.S. -- Paul Richards