Attn: John Spencer (Upper and Lower Case)

[Bill]

Hi,

Thank you so much and it works. Wow!!!

Is there a way to search Last Name and First Name if it will collect anything like:

L00K should be LOOK ( ZERO "0" same as Letter "O" )

1ook should be Look ( ONE "1" same as Letter "L" )

Will I be able to collect "One" or "Zero" from Last Name and First Name?

Your help would be much appreciated.

Thanks


****************************************************************************

You could use the Instr function to do a case sensitive compare?

SELECT YourField
FROM YourTable
WHERE Instr(1,UCase(YourField),YourField,0) = 0

 

[Michel Walsh]

Hi,


With Access 2002:

WHERE Replace(Replace(ArgFirstName, "0", "O"), "1", "l" ) = StoredFirstName

would replace the 0 for o and 1 for l before making a comparison with the stored value (I assume we already have replace the wrong spellings occurring there once for all) in the field of the table.




Since I don't know the context, that may not fit at all in your application.


Vanderghast, Access MVP




Hi,

Thank you so much and it works. Wow!!!

Is there a way to search Last Name and First Name if it will collect anything like:

L00K should be LOOK ( ZERO "0" same as Letter "O" )

1ook should be Look ( ONE "1" same as Letter "L" )

Will I be able to collect "One" or "Zero" from Last Name and First Name?

Your help would be much appreciated.

Thanks


****************************************************************************

You could use the Instr function to do a case sensitive compare?

SELECT YourField
FROM YourTable
WHERE Instr(1,UCase(YourField),YourField,0) = 0