jfriel said:
Is there a way to perform an update query that is case
sensitive? I am trying to run an update query on a field
that contains the same text but in a different case, (eg.
lower case and upper case), with each case having a
seperate primary key.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
How can each case have a separate PK? If there is something in the PK
that indicates Ucase or Lcase then you could use that in a criteria;
otherwise, you'll have to use the Instr() function w/ binary comparison:
WHERE InStr(1, column_name, string, 0) > 0
On large tables this will be slow 'cuz the entire table will be scanned
to evaluate the function InStr(). That's why I asked if there is some
flag in the PK that indicates Ucase or Lcase.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQlW1B4echKqOuFEgEQKjfgCfS2i+YrEDwVpKaaH4WvGWdkV+j9sAn35a
z+U8qgE7uM89wVa9aE+Yle9a
=1aux
-----END PGP SIGNATURE-----