Got a problem!

I have to check a DB to see if a record is a duplicate.  The main 
thing I am checking is first and last name.  These name often have 
apostrophe's!!!!  How in the world am I going to use findfirst or 
seek this way?  

The only thing I can think of is to write a program to substitute 
them for another character before searching, then change them back.  
This database has a lot of records, probably going to be about 500k.  

Any ideas?

Chris







'// =======================================================
    Rules : http://ReliableAnswers.com/List/Rules.asp
    Home  : http://groups.yahoo.com/group/vbHelp/
    =======================================================
    Post  : [email protected]
    Join  : [EMAIL PROTECTED]
    Leave : [EMAIL PROTECTED]
'// =======================================================
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/vbhelp/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to